Hi All,
SAP full backup failing with code "SQL2048N An error occurred while accessing object "0". Reason code: "6".
"
i am not find any wrong in my TSM setup.
I can able to set my TDP password as well.
I can see the log in DB2 as "The BACKUP_IN_PROGRESS state is already on for this tablespace.
This tablespace is already in the midst of being backed up and
cannot have a concurrent backup on it."
Please let me how to troubleshoot this one.Thanks in advance.
xxxx:db2bpp 2> /usr/tivoli/tsm/tdp_r3/db264/backom -c password -e /db2/BPP/
===============================================================================
Data Protection for SAP(R) - Backup Object Manager
- Version 6, Release 1, Modification 0 Level 2 for AIX LF 64-bit -
Build: 367T compiled on Apr 24 2009
(c) Copyright IBM Corporation, 1996, 2009, All Rights Reserved.
===============================================================================
BKI8540I: Using ProLE at xxxxx:tdpr3db264
BKI8558I: Setting TSM password for partition 'NODE0000' on host 'xxxxx'.
BKI0049I: Please enter password for node on server TSM_RED_BPP_SAPW:
BKI0051I: Password successfully verified for node on server TSM_RED_BPP_SAPW.
BKI8512I: Return code is: 0
********************************************
backom.log:
------------------------- Sun Sep 30 04:42:38 2012 -------------------------
BKI8806I: Data Protection for SAP(R) - BackOM 6.1.0.2 (367T) Apr 24 2009
BKI2027I: Using TSM-API version 5.5.1.13 (compiled with 5.3.0.0).
BKI8652I: DB2 version 'SQL09074' with 64 bits detected.
BKI8511I: The command is: -c b_db -a BPP -B 12 -S 2 -P 8 -e /db2/BPP/dbs/initBPP_WEEKLY.utl -O -L
BKI8637I: Full online backup of 'BPP' started ...
BKI8643I: Using vendor library at '/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a' ...
BKI8639I: Including log files in backup image ...
BKI8654I: Using an autonomic buffer size with 12 buffers ...
BKI8641I: Using 2 session(s) ...
BKI8642I: Using a degree of parallelism of 8 ...
SQL2048N An error occurred while accessing object "0". Reason code: "6".
BKI8548I: Elapsed time: 1 sec
BKI8634E: Backup command failed due to an error.
BKI8512I: Return code is: 605
*******************************************
db2diag.log:
2012-09-30-04.42.38.719533+060 E1255710039A443 LEVEL: Info
PID : 14745646 TID : 28276 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17385 APPID: *LOCAL.db2bpp.120930034238
AUTHID : DB2BPP
EDUID : 28276 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1604
MESSAGE : Starting an online db backup.
2012-09-30-04.42.39.033109+060 E1255710483A471 LEVEL: Info
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:762
DATA #1 : <preformatted>
Autonomic BAR - using parallelism = 8.
2012-09-30-04.42.39.036672+060 E1255710955A506 LEVEL: Info
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:876
DATA #1 : <preformatted>
Autonomic BAR - heap consumption.
Targetting (50%) - 1632 of 3264 pages.
2012-09-30-04.42.39.036830+060 E1255711462A497 LEVEL: Info
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:1127
DATA #1 : <preformatted>
Autonomic backup - tuning enabled.
Using buffer size = 129, number = 12.
2012-09-30-04.42.39.036977+060 E1255711960A557 LEVEL: Severe
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1687
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2048
DATA #2 : Hexdump, 12 bytes
0x0700000053381210 : FFFF F800 0000 0000 0000 0006 ............
2012-09-30-04.42.39.037108+060 E1255712518A918 LEVEL: Severe
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1687
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
"".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 3
sqlerrmc: 0 6
sqlerrp : sqlubBui
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2012-09-30-04.42.39.037297+060 E1255713437A728 LEVEL: Error
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1690
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
"".
DATA #1 : String, 166 bytes
The BACKUP_IN_PROGRESS state is already on for this tablespace.
This tablespace is already in the midst of being backed up and
cannot have a concurrent backup on it.
DATA #2 : String, 11 bytes
SYSCATSPACE
2012-09-30-04.42.39.076863+060 E1255714166A421 LEVEL: Severe
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:911
MESSAGE : Backup terminated.
2012-09-30-04.42.41.562175+060 I1255714588A753 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:655
DATA #1 : String, 142 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library /usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a:
DATA #2 : Hexdump, 48 bytes
0x0700000052FEDE90 : 0000 000B 424B 4935 3031 3445 3A20 5469 ....BKI5014E: Ti
0x0700000052FEDEA0 : 766F 6C69 2053 746F 7261 6765 204D 616E voli Storage Man
0x0700000052FEDEB0 : 6100 0000 0000 0000 0000 0000 0000 0000 a...............
2012-09-30-04.42.41.562362+060 E1255715342A348 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:737
MESSAGE : Media controller -- Generic error
2012-09-30-04.42.41.562470+060 E1255715691A397 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:737
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
"".
2012-09-30-04.42.41.562641+060 E1255716089A377 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:737
DATA #1 : String, 45 bytes
/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a.11
SAP full backup failing with code "SQL2048N An error occurred while accessing object "0". Reason code: "6".
"
i am not find any wrong in my TSM setup.
I can able to set my TDP password as well.
I can see the log in DB2 as "The BACKUP_IN_PROGRESS state is already on for this tablespace.
This tablespace is already in the midst of being backed up and
cannot have a concurrent backup on it."
Please let me how to troubleshoot this one.Thanks in advance.
xxxx:db2bpp 2> /usr/tivoli/tsm/tdp_r3/db264/backom -c password -e /db2/BPP/
===============================================================================
Data Protection for SAP(R) - Backup Object Manager
- Version 6, Release 1, Modification 0 Level 2 for AIX LF 64-bit -
Build: 367T compiled on Apr 24 2009
(c) Copyright IBM Corporation, 1996, 2009, All Rights Reserved.
===============================================================================
BKI8540I: Using ProLE at xxxxx:tdpr3db264
BKI8558I: Setting TSM password for partition 'NODE0000' on host 'xxxxx'.
BKI0049I: Please enter password for node on server TSM_RED_BPP_SAPW:
BKI0051I: Password successfully verified for node on server TSM_RED_BPP_SAPW.
BKI8512I: Return code is: 0
********************************************
backom.log:
------------------------- Sun Sep 30 04:42:38 2012 -------------------------
BKI8806I: Data Protection for SAP(R) - BackOM 6.1.0.2 (367T) Apr 24 2009
BKI2027I: Using TSM-API version 5.5.1.13 (compiled with 5.3.0.0).
BKI8652I: DB2 version 'SQL09074' with 64 bits detected.
BKI8511I: The command is: -c b_db -a BPP -B 12 -S 2 -P 8 -e /db2/BPP/dbs/initBPP_WEEKLY.utl -O -L
BKI8637I: Full online backup of 'BPP' started ...
BKI8643I: Using vendor library at '/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a' ...
BKI8639I: Including log files in backup image ...
BKI8654I: Using an autonomic buffer size with 12 buffers ...
BKI8641I: Using 2 session(s) ...
BKI8642I: Using a degree of parallelism of 8 ...
SQL2048N An error occurred while accessing object "0". Reason code: "6".
BKI8548I: Elapsed time: 1 sec
BKI8634E: Backup command failed due to an error.
BKI8512I: Return code is: 605
*******************************************
db2diag.log:
2012-09-30-04.42.38.719533+060 E1255710039A443 LEVEL: Info
PID : 14745646 TID : 28276 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17385 APPID: *LOCAL.db2bpp.120930034238
AUTHID : DB2BPP
EDUID : 28276 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1604
MESSAGE : Starting an online db backup.
2012-09-30-04.42.39.033109+060 E1255710483A471 LEVEL: Info
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:762
DATA #1 : <preformatted>
Autonomic BAR - using parallelism = 8.
2012-09-30-04.42.39.036672+060 E1255710955A506 LEVEL: Info
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:876
DATA #1 : <preformatted>
Autonomic BAR - heap consumption.
Targetting (50%) - 1632 of 3264 pages.
2012-09-30-04.42.39.036830+060 E1255711462A497 LEVEL: Info
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:1127
DATA #1 : <preformatted>
Autonomic backup - tuning enabled.
Using buffer size = 129, number = 12.
2012-09-30-04.42.39.036977+060 E1255711960A557 LEVEL: Severe
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1687
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2048
DATA #2 : Hexdump, 12 bytes
0x0700000053381210 : FFFF F800 0000 0000 0000 0006 ............
2012-09-30-04.42.39.037108+060 E1255712518A918 LEVEL: Severe
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1687
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
"".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 3
sqlerrmc: 0 6
sqlerrp : sqlubBui
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2012-09-30-04.42.39.037297+060 E1255713437A728 LEVEL: Error
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1690
MESSAGE : SQL2048N An error occurred while accessing object "". Reason code:
"".
DATA #1 : String, 166 bytes
The BACKUP_IN_PROGRESS state is already on for this tablespace.
This tablespace is already in the midst of being backed up and
cannot have a concurrent backup on it.
DATA #2 : String, 11 bytes
SYSCATSPACE
2012-09-30-04.42.39.076863+060 E1255714166A421 LEVEL: Severe
PID : 14745646 TID : 16451 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000 DB : BPP
APPHDL : 0-17390 APPID: *LOCAL.db2bpp.120930034243
AUTHID : DB2BPP
EDUID : 16451 EDUNAME: db2agent (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:911
MESSAGE : Backup terminated.
2012-09-30-04.42.41.562175+060 I1255714588A753 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:655
DATA #1 : String, 142 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library /usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a:
DATA #2 : Hexdump, 48 bytes
0x0700000052FEDE90 : 0000 000B 424B 4935 3031 3445 3A20 5469 ....BKI5014E: Ti
0x0700000052FEDEA0 : 766F 6C69 2053 746F 7261 6765 204D 616E voli Storage Man
0x0700000052FEDEB0 : 6100 0000 0000 0000 0000 0000 0000 0000 a...............
2012-09-30-04.42.41.562362+060 E1255715342A348 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:737
MESSAGE : Media controller -- Generic error
2012-09-30-04.42.41.562470+060 E1255715691A397 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:737
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
"".
2012-09-30-04.42.41.562641+060 E1255716089A377 LEVEL: Error
PID : 14745646 TID : 20443 PROC : db2sysc 0
INSTANCE: db2bpp NODE : 000
EDUID : 20443 EDUNAME: db2med.28276.1 (BPP) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:737
DATA #1 : String, 45 bytes
/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a.11
