Database/DB23 [DB2] db2look Sequence 추출 db2look -d DB명 -a -e | grep -i restart > restart.sql db2 connect to testdb db2 -tvf restart.sql 2024. 3. 4. [DB2] Catalog 등록 1. catalog 등록 db2 catalog tcpip remote server db2 catalog db [ as ALIAS ] at node 2. catalog 해제 db2 uncatalog node db2 uncatalog db 2023. 6. 22. [DB2] 테이블 압축(Compress) 여부 확인 select cast(tabschema as varchar(10)) as tabschema ,cast(tabname as varchar(30)) as tabname ,type ,compression ,owner ,cast(tbspace as varchar(20)) as tbspace ,cast(index_tbspace as varchar(20)) as indspace from syscat.tables where tabschema NOT LIKE 'SYS%' and type='T' AND tabname LIKE 'D%' AND tabname NOT LIKE 'D%\_L' ESCAPE '\' AND COMPRESSION 'R' order by tabschema ,tabname WITH ur ; Compres.. 2022. 4. 6. 이전 1 다음