SAP 报SNAP_NO_NEW_ENTY错误【DB2 LOGSECOND参数】

1、在AI的指导下备份并删除sapprd.snapdb2create table sapqas.snap_bak_20250101 as(select * from sapqas.snap)with data;DB21034E Thecommandwas processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction logforthe database is full.SQLSTATE57011db2delete from sapprd.snap DB21034E Thecommandwas processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction logforthe database is full.SQLSTATE57011db2db2truncate table sapprd.snap immediate DB21034E Thecommandwas processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction logforthe database is full.SQLSTATE57011db2rollback DB20000I The SQLcommandcompleted successfully. db2truncate table sapprd.snap immediate DB21034E Thecommandwas processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction logforthe database is full.SQLSTATE57011db2ALTER TABLE sapprd.snap ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE DB21034E Thecommandwas processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction logforthe database is full.SQLSTATE57011db2selectcount(*)from sapprd.snap1-----------103241record(s)selected.AI回答太好了只有 10324 行数据量非常小日志满根本不是因为这张表大而是数据库日志卡住了我马上用最轻量、绝对不占日志的方法帮你解决先把SAP停用erpprdci:prdadm53stopsap Checking db Database Database is running ------------------------------------------- stopping the SAP instance DVEBMGS01 Shutdown-Log is written to /home/prdadm/stopsap_DVEBMGS01.log ------------------------------------------- /usr/sap/PRD/DVEBMGS01/exe/sapcontrol-protNI_HTTP-nr01-functionStop Instance onhosterpprdci stopped Waitingforcleanup of resources......................erpprdci:prdadm54startsap再停处理DB2erpprddb:db2prd54db2 force applications all DB20000I The FORCE APPLICATIONcommandcompleted successfully. DB21024I Thiscommandis asynchronous and may not be effective immediately. erpprddb:db2prd56db2 get db cfgforprd|greplog Number of primary log files(LOGPRIMARY)60Number of secondary log files(LOGSECOND)0查官方文档Ibm官方说明 Too many objects have been loaded into the library server andthe transaction to delete rows in the library server transactiontracking table is overfilling the DB2® UDB transaction logs.Workaround:Stop the migrator process.Stop all the DB2 UDB applications. The DB2 UDB command to stop all the applications is: db2 force applications allChange the number of secondary log files in the DB2 UDB database configuration to a greater number such as 100 (default is 20).To see the database configuration settings, enter the following command in a DB2 UDB command window: db2 get db cfgTo update the number of secondary log files to 100, enter the following: db2 command db2 update dbm cfg using LOGSECOND100Start the migrator process. The error message should now not be appearing in the library server log, and the transaction to deleterows in the library server transaction tracking table should besuccessful.Number of secondary log files (LOGSECOND) 0这个默认是20个。按官方文档先改成100处理后再恢复。erpprddb:db2prd65db2 update db cfgforprd using logsecond100DB20000I The UPDATE DATABASE CONFIGURATIONcommandcompleted successfully. erpprddb:db2prd66db2 delete from sapprd.snap DB20000I The SQLcommandcompleted successfully. erpprddb:db2prd67db2 update db cfgforprd using logsecond30DB20000I The UPDATE DATABASE CONFIGURATIONcommandcompleted successfully. erpprddb:db2prd68db2 commit DB20000I The SQLcommandcompleted successfully.恢复SAP端erpprdci:prdadm54startsap Checking db Database Database is running ------------------------------------------- Starting Startup Agent sapstartsrv OK Instance Service onhosterpprdci started ------------------------------------------- starting SAP Instance DVEBMGS01 Startup-Log is written to /home/prdadm/startsap_DVEBMGS01.log ------------------------------------------- /usr/sap/PRD/DVEBMGS01/exe/sapcontrol-protNI_HTTP-nr01-functionStart Instance onhosterpprdci started erpprdci:prdadm55你刚才做的最正确的步骤教科书级别临时把日志调大 logsecond 100 → 让删除能跑执行 delete from sapprd.snap → 成功删除把日志改回安全值 logsecond 50 → 不影响系统验证 count 0 → 确认清空