SQL0964C The transaction log for the database is ...

Former Member · ‎06-27-2014

Hi,

i am planning to do QAS refresh from PRD system using Client export\import method. i have done export in PRD and the same has been moved to QAS then started imported.

DB Size:160gb

DB:DB2 9.7

os: windows 2008.

I facing SQL0964C The transaction log for the database is full issue while client import and regarding this i have raised incident to SAP then they replied to increase some parameter like(LOGPRIMARY,LOGSECOND,LOGFILSIZ) temporarily and revert them back after the import. Based on that i have increased from as below mentioned calculation.

the filesystem size of /db2/<SID>/log_dir should be greater than LOGFILSIZ*4*(Sum of LOGPRIMARY+LOGSECONDARY) KB

From:

Log file size (4KB) (LOGFILSIZ) = 60000

Number of primary log files (LOGPRIMARY) = 50

Number of secondary log files (LOGSECOND) = 100

Total drive space required: 33GB

To:

Log file size (4KB) (LOGFILSIZ) = 70000

Number of primary log files (LOGPRIMARY) = 60

Number of secondary log files (LOGSECOND) = 120

Total drive space required: 47GB

But still facing the same issue. Please help me to resolve the ASAP.

Last error TP log details:

3 ETW674Xstart import of "R3TRTABUFAGLFLEX08" ...

4 ETW000 1 entry from FAGLFLEX08 (210) deleted.

4 ETW000 1 entry for FAGLFLEX08 inserted (210*).

4 ETW675 end import of "R3TRTABUFAGLFLEX08".

3 ETW674Xstart import of "R3TRTABUFAGLFLEXA" ...

4 ETW000 [ dev trc,00000] Fri Jun 27 02:20:21 2014 -774509399 65811.628079

4 ETW000 [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4980] CON = 0 (BEGIN) 85 65811.628164

4 ETW000 [ dev trc,00000] &+ DbSlModifyDB6( SQLExecute 😞 [IBM][CLI Driver][DB2/NT64] SQL0964C The transaction log for the database is full.

4 ETW000 83 65811.628247

4 ETW000 [ dev trc,00000] &+ SQLSTATE=57011 row=1

4 ETW000 51 65811.628298

4 ETW000 [ dev trc,00000] &+

4 ETW000 67 65811.628365

4 ETW000 [ dev trc,00000] &+ DELETE FROM "FAGLFLEXA" WHERE "RCLNT" = ?

4 ETW000 62 65811.628427

4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=8, reopt=0

4 ETW000 58 65811.628485

4 ETW000 [ dev trc,00000] &+

4 ETW000 53 65811.628538

4 ETW000 [ dev trc,00000] &+ Input SQLDA:

4 ETW000 52 65811.628590

4 ETW000 [ dev trc,00000] &+ 1 CT=WCHAR T=VARCHAR L=6 P=9 S=0

4 ETW000 49 65811.628639

4 ETW000 [ dev trc,00000] &+

4 ETW000 50 65811.628689

4 ETW000 [ dev trc,00000] &+ Input data:

4 ETW000 49 65811.628738

4 ETW000 [ dev trc,00000] &+ row 1: 1 WCHAR I=6 "210" 34 65811.628772

4 ETW000 [ dev trc,00000] &+

4 ETW000 51 65811.628823

4 ETW000 [ dev trc,00000] &+

4 ETW000 50 65811.628873

4 ETW000 [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4980] (END) 27 65811.628900

4 ETW000 [ dbtran ,00000] ***LOG BY4=>sql error -964 performing DEL on table FAGLFLEXA

4 ETW000 3428 65811.632328

4 ETW000 [ dbtran ,00000] ***LOG BY0=>SQL0964C The transaction log for the database is full. SQLSTATE=57011 row=1

4 ETW000 46 65811.632374

4 ETW000 [ dev trc,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL' 59 65811.632433

4 ETW000 RSLT: {dbsl=99, tran=1}

4 ETW000 FHDR: {tab='FAGLFLEXA', fcode=194, mode=2, bpb=0, dbcnt=0, crsr=0,

4 ETW000 hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,

4 ETW000 init:p=0000000000000000, init:#=0, wa:p=0X00000000020290C0, wa:#=10000}

4 ETW000 [ dev trc,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL' 126 65811.632559

4 ETW000 STMT: {stmt:#=0, bndfld:#=1, prop=0, distinct=0,

4 ETW000 fld:#=0, alias:p=0000000000000000, fupd:#=0, tab:#=1, where:#=2,

4 ETW000 groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0}

4 ETW000 CRSR: {tab='', id=0, hold=0, prop=0, max.in@0=1, fae:blk=0,

4 ETW000 con:id=0, con:vndr=7, val=2,

4 ETW000 key:#=3, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=0X00000001421A3000}

2EETW125 SQL error "-964" during "-964" access: "SQL0964C The transaction log for the database is full. SQLSTATE=57011 row=1"

4 ETW690 COMMIT "14208" "-1"

4 ETW000 [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4980] CON = 0 (BEGIN) 16208 65811.648767

4 ETW000 [ dev trc,00000] &+ DbSlModifyDB6( SQLExecute 😞 [IBM][CLI Driver][DB2/NT64] SQL0964C The transaction log for the database is full.

4 ETW000 75 65811.648842

4 ETW000 [ dev trc,00000] &+ SQLSTATE=57011 row=1

4 ETW000 52 65811.648894

4 ETW000 [ dev trc,00000] &+

4 ETW000 51 65811.648945

4 ETW000 [ dev trc,00000] &+ INSERT INTO DDLOG (SYSTEMID, TIMESTAMP, NBLENGTH, NOTEBOOK) VALUES ( ? , CHAR( CURRENT TIMESTAMP - CURRENT TIME

4 ETW000 50 65811.648995

4 ETW000 [ dev trc,00000] &+ ZONE ), ?, ? )

4 ETW000 49 65811.649044

4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=15, reopt=0

4 ETW000 55 65811.649099

4 ETW000 [ dev trc,00000] &+

4 ETW000 49 65811.649148

4 ETW000 [ dev trc,00000] &+ Input SQLDA:

4 ETW000 50 65811.649198

4 ETW000 [ dev trc,00000] &+ 1 CT=WCHAR T=VARCHAR L=44 P=66 S=0

4 ETW000 47 65811.649245

4 ETW000 [ dev trc,00000] &+ 2 CT=SHORT T=SMALLINT L=2 P=2 S=0

4 ETW000 48 65811.649293

4 ETW000 [ dev trc,00000] &+ 3 CT=BINARY T=VARBINARY L=32000 P=32000 S=0

4 ETW000 47 65811.649340

4 ETW000 [ dev trc,00000] &+

4 ETW000 50 65811.649390

4 ETW000 [ dev trc,00000] &+ Input data:

4 ETW000 49 65811.649439

4 ETW000 [ dev trc,00000] &+ row 1: 1 WCHAR I=14 "R3trans" 32 65811.649471

4 ETW000 [ dev trc,00000] &+ 2 SHORT I=2 12744 32 65811.649503

4 ETW000 [ dev trc,00000] &+ 3 BINARY I=12744 00600306003200300030003900300033003300310031003300320036003400390000...

4 ETW000 64 65811.649567

4 ETW000 [ dev trc,00000] &+

4 ETW000 52 65811.649619

4 ETW000 [ dev trc,00000] &+

4 ETW000 51 65811.649670

4 ETW000 [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4980] (END) 28 65811.649698

4 ETW000 [ dbsyntsp,00000] ***LOG BY4=>sql error -964 performing SEL on table DDLOG 36 65811.649734

4 ETW000 [ dbsyntsp,00000] ***LOG BY0=>SQL0964C The transaction log for the database is full. SQLSTATE=57011 row=1

4 ETW000 46 65811.649780

4 ETW000 [ dbsync ,00000] ***LOG BZY=>unexpected return code 2 calling ins_ddlog 37 65811.649817

4 ETW000 [ dev trc,00000] db_syflush (TRUE) failed 26 65811.649843

4 ETW000 [ dev trc,00000] db_con_commit received error 1024 in before-commit action, returning 8

4 ETW000 57 65811.649900

4 ETW000 [ dbeh.c ,00000] *** ERROR => missing return code handler 1974 65811.651874

4 ETW000 caller does not handle code 1024 from dblink#5[321]

4 ETW000 ==> calling sap_dext to abort transaction

2EETW000 sap_dext called with msgnr "900":

2EETW125 SQL error "-964" during "-964" access: "SQL0964C The transaction log for the database is full. SQLSTATE=57011 row=1"

1 ETP154 MAIN IMPORT

1 ETP110 end date and time : "20140627022021"

1 ETP111 exit code : "12"

1 ETP199 ######################################

Regards,

Rajesh

former_member195432 · ‎06-27-2014

Hi Gajendra,

Based on size of your /db2/<SID>/log_dir , you can increase DB2 parameters(LOGPRIMARY,LOGSECOND,LOGFILSIZ).

There is limit for logprimary and logsecond. ie Logprimary+logsecondary <= 255

You can also use below query to check log space utilization.

select LOG_UTILIZATION_PERCENT,TOTAL_LOG_USED_KB,TOTAL_LOG_AVAILABLE_KB from sysibmadm.log_utilization

Regards,

Vikash

divyanshu_srivastava3 · ‎06-27-2014

Hi Babu,

I believe you should have taken a restart of your system if log primary are changed. If so, then increase log primary to 120 and secondary to 80 provide size and space are enough.

Note 1293475 - DB6: Transaction Log Full

Note 1308895 - DB6: File System for Transaction Log is Full

Note: 495297 - DB6: Monitoring transaction log

Regards,

Divyanshu

former_member188883 · ‎06-27-2014

Hi Gajendra,

You need to ensure the log_dir and log_archive has enough space while import is running.

There is a possibility that either of the filesystems are getting full.

Hope this helps.

Regards,

Deepak Kori

SQL0964C The transaction log for the database is full

Accepted Solutions (0)

Answers (3)

Answers (3)

Re: SSO using OKTA - launches FLP twice

Re: CF Deployment Error: Error getting tenant t0

Feature Request: Allow Process Intelligence Consum...

Re: [XSLT]: Dynamic rows creation and values(in co...

Re: Connecting SAP CAP with SAP Cloud ALM