DB2 online backup failed - DB12

[Former Member]

Hi Experts,

Our online DB backup is failing with the following error log below taken from DB12. I can see no error below from the log except only for the return code 2062-. Anyone knows what this mean. Thanks and in advance.

Logs:

Backup Timestamp : 06/13/2011 21:30:05 (20110613213005)

End Timestamp : 06/13/2011 21:49:11 (20110613214911)

Runtime : 00:19:06

Partition : 0

Backup Sequences : 9

Return Code : 2062-

Error Text :

Status : Active

Backup Type : Online

Backup Granularity : Database

Backup Device : Other

First Log File : S0160958.LOG

Last Log File :

Comments : DB2 BACKUP CEP ONLINE

No. Tablespaces : 306

Tablespaces (Seq.) : 'SYSCATSPACE' (1)

'SYSTOOLSPACE' (1)

'CEP#DBD' (1)

'CEP#DBI' (1)

'CEP#STABD' (1)

'CEP#STABI' (1)

'CEP#BTABD' (1)

'CEP#BTABI' (1)

'CEP#CLUD' (1)

'CEP#CLUI' (1)

'CEP#POOLD' (1)

'CEP#POOLI' (1)

'CEP#DDICD' (1)

'CEP#DDICI' (1)

'CEP#DOCUD' (1)

'CEP#DOCUI' (1)

'CEP#EL700D' (1)

'CEP#EL700I' (1)

'CEP#LOADD' (1)

'CEP#LOADI' (1)

'CEP#PROTD' (1)

'CEP#PROTI' (1)

'CEP#ES700D' (1)

'CEP#ES700I' (1)

'CEP#SOURCED' (1)

'CEP#SOURCEI' (1)

'CEP#USER1D' (1)

'CEP#USER1I' (1)

'CEP#DIMD' (1)

'CEP#DIMI' (1)

'CEP#FACTD' (1)

'CEP#FACTI' (1)

'CEP#ODSD' (1)

'CEP#ODSI' (1)

'SYSCATSPACE' (2)

'SYSTOOLSPACE' (2)

'CEP#DBD' (2)

'CEP#DBI' (2)

'CEP#STABD' (2)

'CEP#STABI' (2)

'CEP#BTABD' (2)

'CEP#BTABI' (2)

'CEP#CLUD' (2)

'CEP#CLUI' (2)

'CEP#POOLD' (2)

'CEP#POOLI' (2)

'CEP#DDICD' (2)

'CEP#DDICI' (2)

'CEP#DOCUD' (2)

'CEP#DOCUI' (2)

'CEP#EL700D' (2)

'CEP#EL700I' (2)

'CEP#LOADD' (2)

'CEP#LOADI' (2)

'CEP#PROTD' (2)

'CEP#PROTI' (2)

'CEP#ES700D' (2)

'CEP#ES700I' (2)

'CEP#SOURCED' (2)

'CEP#SOURCEI' (2)

'CEP#USER1D' (2)

'CEP#USER1I' (2)

'CEP#DIMD' (2)

'CEP#DIMI' (2)

'CEP#FACTD' (2)

'CEP#FACTI' (2)

'CEP#ODSD' (2)

'CEP#ODSI' (2)

'SYSCATSPACE' (3)

'SYSTOOLSPACE' (3)

'CEP#DBD' (3)

'CEP#DBI' (3)

'CEP#STABD' (3)

'CEP#STABI' (3)

'CEP#BTABD' (3)

'CEP#BTABI' (3)

'CEP#CLUD' (3)

'CEP#CLUI' (3)

'CEP#POOLD' (3)

'CEP#POOLI' (3)

'CEP#DDICD' (3)

'CEP#DDICI' (3)

'CEP#DOCUD' (3)

'CEP#DOCUI' (3)

'CEP#EL700D' (3)

'CEP#EL700I' (3)

'CEP#LOADD' (3)

'CEP#LOADI' (3)

'CEP#PROTD' (3)

'CEP#PROTI' (3)

'CEP#ES700D' (3)

'CEP#ES700I' (3)

'CEP#SOURCED' (3)

'CEP#SOURCEI' (3)

'CEP#USER1D' (3)

'CEP#USER1I' (3)

'CEP#DIMD' (3)

'CEP#DIMI' (3)

'CEP#FACTD' (3)

'CEP#FACTI' (3)

'CEP#ODSD' (3)

'CEP#ODSI' (3)

'SYSCATSPACE' (4)

'SYSTOOLSPACE' (4)

'CEP#DBD' (4)

'CEP#DBI' (4)

'CEP#STABD' (4)

'CEP#STABI' (4)

'CEP#BTABD' (4)

'CEP#BTABI' (4)

'CEP#CLUD' (4)

'CEP#CLUI' (4)

'CEP#POOLD' (4)

'CEP#POOLI' (4)

'CEP#DDICD' (4)

'CEP#DDICI' (4)

'CEP#DOCUD' (4)

'CEP#DOCUI' (4)

'CEP#EL700D' (4)

'CEP#EL700I' (4)

'CEP#LOADD' (4)

'CEP#LOADI' (4)

'CEP#PROTD' (4)

'CEP#PROTI' (4)

'CEP#ES700D' (4)

'CEP#ES700I' (4)

'CEP#SOURCED' (4)

'CEP#SOURCEI' (4)

'CEP#USER1D' (4)

'CEP#USER1I' (4)

'CEP#DIMD' (4)

'CEP#DIMI' (4)

'CEP#FACTD' (4)

'CEP#FACTI' (4)

'CEP#ODSD' (4)

'CEP#ODSI' (4)

'SYSCATSPACE' (5)

'SYSTOOLSPACE' (5)

'CEP#DBD' (5)

'CEP#DBI' (5)

'CEP#STABD' (5)

'CEP#STABI' (5)

'CEP#BTABD' (5)

'CEP#BTABI' (5)

'CEP#CLUD' (5)

'CEP#CLUI' (5)

'CEP#POOLD' (5)

'CEP#POOLI' (5)

'CEP#DDICD' (5)

'CEP#DDICI' (5)

'CEP#DOCUD' (5)

'CEP#DOCUI' (5)

'CEP#EL700D' (5)

'CEP#EL700I' (5)

'CEP#LOADD' (5)

'CEP#LOADI' (5)

'CEP#PROTD' (5)

'CEP#PROTI' (5)

'CEP#ES700D' (5)

'CEP#ES700I' (5)

'CEP#SOURCED' (5)

'CEP#SOURCEI' (5)

'CEP#USER1D' (5)

'CEP#USER1I' (5)

'CEP#DIMD' (5)

'CEP#DIMI' (5)

'CEP#FACTD' (5)

'CEP#FACTI' (5)

'CEP#ODSD' (5)

'CEP#ODSI' (5)

'SYSCATSPACE' (6)

'SYSTOOLSPACE' (6)

'CEP#DBD' (6)

'CEP#DBI' (6)

'CEP#STABD' (6)

'CEP#STABI' (6)

'CEP#BTABD' (6)

'CEP#BTABI' (6)

'CEP#CLUD' (6)

'CEP#CLUI' (6)

'CEP#POOLD' (6)

'CEP#POOLI' (6)

'CEP#DDICD' (6)

'CEP#DDICI' (6)

'CEP#DOCUD' (6)

'CEP#DOCUI' (6)

'CEP#EL700D' (6)

'CEP#EL700I' (6)

'CEP#LOADD' (6)

'CEP#LOADI' (6)

'CEP#PROTD' (6)

'CEP#PROTI' (6)

'CEP#ES700D' (6)

'CEP#ES700I' (6)

'CEP#SOURCED' (6)

'CEP#SOURCEI' (6)

'CEP#USER1D' (6)

'CEP#USER1I' (6)

'CEP#DIMD' (6)

'CEP#DIMI' (6)

'CEP#FACTD' (6)

'CEP#FACTI' (6)

'CEP#ODSD' (6)

'CEP#ODSI' (6)

'SYSCATSPACE' (7)

'SYSTOOLSPACE' (7)

'CEP#DBD' (7)

'CEP#DBI' (7)

'CEP#STABD' (7)

'CEP#STABI' (7)

'CEP#BTABD' (7)

'CEP#BTABI' (7)

'CEP#CLUD' (7)

'CEP#CLUI' (7)

'CEP#POOLD' (7)

'CEP#POOLI' (7)

'CEP#DDICD' (7)

'CEP#DDICI' (7)

'CEP#DOCUD' (7)

'CEP#DOCUI' (7)

'CEP#EL700D' (7)

'CEP#EL700I' (7)

'CEP#LOADD' (7)

'CEP#LOADI' (7)

'CEP#PROTD' (7)

'CEP#PROTI' (7)

'CEP#ES700D' (7)

'CEP#ES700I' (7)

'CEP#SOURCED' (7)

'CEP#SOURCEI' (7)

'CEP#USER1D' (7)

'CEP#USER1I' (7)

'CEP#DIMD' (7)

'CEP#DIMI' (7)

'CEP#FACTD' (7)

'CEP#FACTI' (7)

'CEP#ODSD' (7)

'CEP#ODSI' (7)

'SYSCATSPACE' (8)

'SYSTOOLSPACE' (8)

'CEP#DBD' (8)

'CEP#DBI' (8)

'CEP#STABD' (8)

'CEP#STABI' (8)

'CEP#BTABD' (8)

'CEP#BTABI' (8)

'CEP#CLUD' (8)

'CEP#CLUI' (8)

'CEP#POOLD' (8)

'CEP#POOLI' (8)

'CEP#DDICD' (8)

'CEP#DDICI' (8)

'CEP#DOCUD' (8)

'CEP#DOCUI' (8)

'CEP#EL700D' (8)

'CEP#EL700I' (8)

'CEP#LOADD' (8)

'CEP#LOADI' (8)

'CEP#PROTD' (8)

'CEP#PROTI' (8)

'CEP#ES700D' (8)

'CEP#ES700I' (8)

'CEP#SOURCED' (8)

'CEP#SOURCEI' (8)

'CEP#USER1D' (8)

'CEP#USER1I' (8)

'CEP#DIMD' (8)

'CEP#DIMI' (8)

'CEP#FACTD' (8)

'CEP#FACTI' (8)

'CEP#ODSD' (8)

'CEP#ODSI' (8)

'SYSCATSPACE' (9)

'SYSTOOLSPACE' (9)

'CEP#DBD' (9)

'CEP#DBI' (9)

'CEP#STABD' (9)

'CEP#STABI' (9)

'CEP#BTABD' (9)

'CEP#BTABI' (9)

'CEP#CLUD' (9)

'CEP#CLUI' (9)

'CEP#POOLD' (9)

'CEP#POOLI' (9)

'CEP#DDICD' (9)

'CEP#DDICI' (9)

'CEP#DOCUD' (9)

'CEP#DOCUI' (9)

'CEP#EL700D' (9)

'CEP#EL700I' (9)

'CEP#LOADD' (9)

'CEP#LOADI' (9)

'CEP#PROTD' (9)

'CEP#PROTI' (9)

'CEP#ES700D' (9)

'CEP#ES700I' (9)

'CEP#SOURCED' (9)

'CEP#SOURCEI' (9)

'CEP#USER1D' (9)

'CEP#USER1I' (9)

'CEP#DIMD' (9)

'CEP#DIMI' (9)

'CEP#FACTD' (9)

'CEP#FACTI' (9)

'CEP#ODSD' (9)

'CEP#ODSI' (9)

Location (Seq.) : /usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (1)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (2)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (3)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (4)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (5)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (6)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (7)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (8)

/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a (9)

[brian_walker · Accepted solution]

From the IBM support site:

An unexpected error occurred while accessing a device, file, or the vendor shared library during the processing of a database utility.

Just based on the error you attached, this would appear to be DB2 LUW and not DB2 z/OS. As such, you may get better answers in the correct forum...

Brian

[Former Member · Accepted solution]

Hi Brian, thanks for posting and comment. Will try to re-post this to different forums.

[Former Member]

	Backup Failed with return code 2062-
10:24:58	Job started
10:24:58	Step 001 started (program RSDBAJOB, variant &0000000000578, user ID CHINMAY)
10:24:58	Backup_Vend:Database Backup with Vendor Library
10:24:58	Backup_Vend:started by CL_DB6_JOB_BACKUP_VENDORLIB    on server vgldqecc
10:24:58	Backup_Vend:Parameter TESTMODE has not been set
10:24:58	Backup_Vend:Parameter PARALLELISM has been set to " 0"
10:24:58	Backup_Vend:Parameter RUNTIME has not been set
10:24:58	Backup_Vend:Parameter BACKUP_MODE has been set to "ONLINE"
10:24:58	Backup_Vend:Parameter PARTITION has not been set
10:24:58	Backup_Vend:Parameter BACKUP_TYPE has been set to ""
10:24:58	Backup_Vend:Parameter COMPRESS has been set to ""
10:24:58	Backup_Vend:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS"
10:24:58	Backup_Vend:Parameter NUMBER_BUFFERS has been set to " 0"
10:24:58	Backup_Vend:Parameter BUFFER_SIZE has been set to " 0"
10:24:58	Backup_Vend:Parameter PARALLELISM has been set to " 0"
10:24:58	Backup_Vend:Parameter UTIL_IMPACT_PRIORITY has not been set
10:24:58	Backup_Vend:Parameter NUMBER_SESSIONS has been set to " 1"
10:24:58	Backup_Vend:Parameter FILE_PATH has been set to "/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a"
10:25:00	Backup_Vend:Command '   'failed
10:25:00	Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r
10:25:00	Backup_Vend:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP
10:25:00	Backup_Vend:  Kernel Error ID:
10:25:00	Backup_Vend:SYSID:
10:25:00	Backup_Vend:  SY-SUBRC: 1208
10:25:00	Backup_Vend:  SY-TABIX: 0
10:25:00	Backup_Vend:  Message: ADBC error
10:25:00	Backup_Vend:  Database:
10:25:00	Backup_Vend:caused by
10:25:00	Backup_Vend:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method EXECUTE_CM
10:25:00	Backup_Vend:  D line 43
10:25:00	Backup_Vend:  Kernel Error ID:
10:25:00	Backup_Vend:  SYSID: QE1
10:25:00	Backup_Vend:  SY-SUBRC: 1208
10:25:00	Backup_Vend:  Message: ADBC error
10:25:00	Backup_Vend:  Command: BACKUP DATABASE QE1 ONLINE LOAD "/usr/tivoli/tsm/tdp_r3/db2
10:25:00	Backup_Vend:  64/libtdpdb264.a" OPEN 1 SESSIONS INCLUDE LOGS
10:25:00	Backup_Vend:  Database:
10:25:00	Backup_Vend:causedby
10:25:00	Backup_Vend:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
10:25:00	Backup_Vend:  Kernel Error ID:
10:25:00	Backup_Vend:  DB Error: Yes
10:25:00	Backup_Vend:  SQL Code: 2062-
10:25:00	Backup_Vend:  SQL Message: SQL2062N An error occurred while accessing media "/us
10:25:00	Backup_Vend:  r/tivoli/tsm/tdp_r3/db264/libtdpdb264.a". Reason code: "11 row=1
10:25:00	Backup_Vend:  DB Object Exists: No
10:25:00	Backup_Vend:  Duplicated Key: No
10:25:00	Backup_Vend:  Internal Error: 1
10:25:00	Backup_Vend:  Invalid Cursor: No
10:25:00	Backup_Vend:  Unknown Connection: No
10:25:00	Backup_Vend:  Connection Closed: No
10:25:00	Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method  line 40
10:25:00	Backup_Vend:terminated with error
10:25:00	REASON=ADBC error
10:25:00	Job finished

db12 log

Backup Timestamp    : 22.08.2013 10:34:54 (20130822103454)

End Timestamp       : 22.08.2013 10:34:55 (20130822103455)

Runtime             : 00:00:01

Partition           : 0

Backup Sequences    : 1

Return Code         : 2062-

Error Text          :

Status              : Active

Backup Type         : Online

Backup Granularity  : Database

Backup Device       : Undef

First Log File      : S0021543.LOG

Last Log File       :

Comments            : DB2 BACKUP QE1 ONLINE

No. Tablespaces     : 32

Tablespaces (Seq.)  : 'SYSCATSPACE' ()

                       'SYSTOOLSPACE' ()

                       'QE1#EL700D' ()

                       'QE1#EL700I' ()

                       'QE1#STABD' ()

                       'QE1#STABI' ()

                       'QE1#BTABD' ()

                       'QE1#BTABI' ()

                       'QE1#POOLD' ()

                       'QE1#POOLI' ()

                       'QE1#CLUD' ()

                       'QE1#CLUI' ()

                       'QE1#DIMD' ()

                       'QE1#DIMI' ()

                       'QE1#FACTD' ()

                       'QE1#FACTI' ()

                       'QE1#ODSD' ()

                       'QE1#ODSI' ()

                       'QE1#DDICD' ()

                       'QE1#DDICI' ()

                       'QE1#DOCUD' ()

                       'QE1#DOCUI' ()

                       'QE1#LOADD' ()

                       'QE1#LOADI' ()

                       'QE1#PROTD' ()

                       'QE1#PROTI' ()

                       'QE1#ES700D' ()

                       'QE1#ES700I' ()

                       'QE1#SOURCED' ()

                       'QE1#SOURCEI' ()

                       'QE1#USER1D' ()

                       'QE1#USER1I' ()

Location (Seq.)     :  ()

[hugo_amo]

Hi Chinmay,

For the error above:

SQL Message: SQL2062N An error occurred while accessing mediar/tivoli/tsm/tdp_r3/db264/libtdpdb264.a". Reason code: "11 row=1

Consult this IBM link from the infocenter:

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.messages.sql.doc%2F...

You need to contact your vendor Tivoli for the meaning of this reason code.

Which DB2 version and fix pack are you currently using?

You may be hitting the following APAR:

http://www-01.ibm.com/support/docview.wss?uid=swg1IC70638

As Brian said, this thread should have been created for the DB6 forum instead. This is exclusively for DB2 on z/OS databases.

Hope the APAR helps, if not please let us know the db2 version and fixpack and it would be good to get the entries in db2diag.log when the backup failed.

Regards,

Hugo