DB2: Get database details

   db2 list db directory > dbdirectory_`date  '+%Y%m%d%H%M'`.txt

   db2 list node directory > nodedirectory_`date  '+%Y%m%d%H%M'`.txt

   db2 "attach to ${DB2INSTANCE}"

   db2 "get dbm cfg show detail" > dbmcfg_`date  '+%Y%m%d%H%M'`.txt

   db2 "get snapshot for all databases" > SnapAllDBs_`date  '+%Y%m%d%H%M'`.txt

    db2set -all > db2set_`date  '+%Y%m%d%H%M'`.txt

   db2cfexp cfexp_`date  '+%Y%m%d%H%M'`.txt backup

   df -h > FSOutput_`date  '+%Y%m%d%H%M'`.txt

   db2level > db2level_`date  '+%Y%m%d%H%M'`.txt

   db2licm -l > DB2LICM_`date  '+%Y%m%d%H%M'`.out

   crontab -l > Cron_`date  '+%Y%m%d%H%M'`.out

   #db2 "list db directory" |egrep -i "Indirect|Database Name"|grep -i "Database Name" > DBNames.out

   db2 "list db directory" |grep -i "Database Name" > DBNames.out

   cat DBNames.out |awk '{print $4}' |while read DB ; do   db2 connect to ${DB};   db2 "get db cfg for ${DB} show detail " > DBCFG_${DB}_`date  '+%Y%m%d%H%M'`.out;   db2 terminate; done

   db2pd -alldbs -hadr > HADRStatus_ALLDBs_`date  '+%Y%m%d%H%M'`.out

   db2 "list active databases" > ActvieDBs_`date  '+%Y%m%d%H%M'`.out

   db2 "list applications" > ListApps_`date  '+%Y%m%d%H%M'`.out

   db2 get dbm cfg > dbm.cfg.out ;

   db2set -all >db2set_all.out;

   db2 "list db directory" |grep -i "Database Name" > $HOME/DBNames.out

   cat $HOME/DBNames.out |awk '{print $4}' |while read DB ; do   db2 connect to ${DB};   db2look -d ${DB} -a -e -x -o $HOME/${DB}_look_all.ddl;   db2look -d ${DB} -x -o $HOME/${DB}_look_grants.ddl;   db2 terminate; done

  

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