DB2: to generate an archive log

 to generate an archive log:

cd /rd500/db2arch_logs/tst4ins4/WCTST10/NODE0000/LOGSTREAM0000/C0000042

WCSTG1:

/rd500/db2arch_logs/stg1ins1/WCSTG1/NODE0000/LOGSTREAM0000/C0000001


WCPRD1:

/rd500/db2arch_logs/prd1ins1/WCPRD1/NODE0000/LOGSTREAM0000/C0000033



db2 terminate    <-- disconnect your session

db2 archive log for db wctst10

DB20000I  The ARCHIVE LOG command completed successfully.

[tst4ins4@db2tst602  C0000042]

$ ls -lrt

total 550084

-rw-r----- 1 tst4ins4 db2iadm1  20209664 Mar 25 06:52 S0039223.LOG

-rw-r----- 1 tst4ins4 db2iadm1   5136384 Mar 25 09:47 S0039224.LOG

-rw-r----- 1 tst4ins4 db2iadm1   6180864 Mar 25 11:38 S0039225.LOG

-rw-r----- 1 tst4ins4 db2iadm1   1859584 Mar 25 12:31 S0039226.LOG

-rw-r----- 1 tst4ins4 db2iadm1   4079616 Mar 25 14:01 S0039227.LOG

-rw-r----- 1 tst4ins4 db2iadm1   4677632 Mar 25 16:40 S0039228.LOG

-rw-r----- 1 tst4ins4 db2iadm1 225288192 Mar 25 19:45 S0039229.LOG

-rw-r----- 1 tst4ins4 db2iadm1  20602880 Mar 26 06:50 S0039230.LOG

-rw-r----- 1 tst4ins4 db2iadm1   6459392 Mar 26 10:35 S0039231.LOG

-rw-r----- 1 tst4ins4 db2iadm1   7585792 Mar 26 12:31 S0039232.LOG

-rw-r----- 1 tst4ins4 db2iadm1 225288192 Mar 26 19:07 S0039233.LOG

-rw-r----- 1 tst4ins4 db2iadm1  29040640 Mar 27 06:49 S0039234.LOG

-rw-r----- 1 tst4ins4 db2iadm1   6877184 Mar 27 09:37 S0039235.LOG


Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more