Db2 command for modifying Log Size

Db2 command to modify the log size 1. view db2 configuration information db2 => get db cfg or get db cfg for <dbname>; 2. you must use db2 connect to BCDL_SX to modify the db2 Log File Size www.2cto.com, instead of db2 connect to BCDL_SX user cmbbcd_sx using cmbbcd_sx. Therefore, you do not have the permission to modify the log file. 3. before the adjustment, make the following three changes: Log file size (4 kb) (LOGFILSIZ) = 16000: Modify the Log file size: update db cfg for <dbname> using LOGFILSIZ 4096 modify the number of master log files: update db cfg for <dbname> using LOGPRIMARY 20 modify the number of auxiliary log files: update db cfg for <dbname> using LOGSECOND 10 www.2cto.com adjusted as follows: Log file size (4 kb) (LOGFILSIZ) = 61440 -- when the Log is full on the current day, the following is the db2 command for modifying the Log Size: db2 connect to BCDL_AHH user cmbbcd_ahh using cmbbcd_ahh. It is useless to log on to the database by using db2admin. You need to modify the db2 command, and then under manage-Service
You also need to change the password, right-click and log on to the password to modify db2 connect to db2admin user db2admin using db2admin. Then, the following is the db2 command FOR modifying logs: db2 "update db cfg for relTCP USING logprimary 12" db2 "update db cfg for relTCP. USING logsecond 20 "db2" update db cfg for relTCP USING logbufsz 32"