Groovy DBA

 select * from pg_settings where name like '%vacuum%'; Or  select * from pg_settings;

  $ db2 get db cfg for wcprd1 | grep -i timeout  Lock timeout (sec)                        (LOCKTIMEOUT) = 45  <-- default is -1 which means never timeout  HADR timeout value                       (HADR_TIMEOUT) = 20  Lock timeout events                   (MON_LOCKTIMEOUT) = NONE

 db2diag -f

 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---...

 db2 "CONNECT TO <database> USER <userid> USING <password> NEW <new_password> CONFIRM <new_password>" db2 "CONNECT TO wcprd1 USER wcs USING old_password NEW <new_password> CONFIRM <new_password>" ALTER USER username IDENTIFIED BY new_password;