on 10-10-2012 4:46 AM
Hi, I have studied the methods for system copy for DB2 from the SAP ones to the DB2 specific methods, and I need to perform a new one without going down on the source system.
I am on IBM AIX 6.1 and have online backups of source system. I have installed from zero a new Netweaver AS ABAP 7.11 (same version as PRD) for Sandbox purposes.
After finishing the install I have performed the redirected restore of DB2 database on my new SBX with succes, but when I want to start the system it doesn´t goes up.
Making a root cause i found that if I execute R3trans -d have the following issue with the DB2 schema that is not recognized properly.
trans.log (File content)
--------------------------------------------------------------------------------------------------------------------------------------------
4 ETW000 R3trans version 6.19 (release 711 - 22.01.09 - 11:27:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 09.10.2012 - 21:27:17
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Oct 9 21:27:17 2012 219 0.000219
4 ETW000 [dev trc ,00000] db_con_init called 24 0.000243
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 56 0.000299
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 40 0.000339
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o' ...
4 ETW000 52 0.000391
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o), hdl 0
4 ETW000 1357 0.001748
4 ETW000 [dev trc ,00000] Library '/usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o' loaded
4 ETW000 42 0.001790
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o
4 ETW000 40 0.001830
4 ETW000 [dev trc ,00000] Version of '/usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o' is "710.21", patchlevel (0.20)
4 ETW000 820 0.002650
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o
4 ETW000 41 0.002691
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/BSX/SYS/exe/uc/rs6000_64/dbdb6slib.o
4 ETW000 84 0.002775
4 ETW000 [dev trc ,00000] New connection 0 created 37 0.002812
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 50 0.002862
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 66 0.002928
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 36 0.002964
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection:
4 ETW000 32 0.002996
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 46 0.003042
4 ETW000 [dev trc ,00000] DB2 library has been loaded. 18769 0.021811
4 ETW000 [dev trc ,00000] Info: successfully loaded DB2 library '/usr/sap/BSX/SYS/global/db6/AIX_64/db6_clidriver/lib/libdb2.a(shr_64.o)'
4 ETW000 83 0.021894
4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 710.21 [opt]
4 ETW000 45 0.021939
4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 27 0.021966
4 ETW000 [dev trc ,00000] (0.3) DB6: patch for VER07781 (note 1226290) 52 0.022018
4 ETW000 [dev trc ,00000] (0.3) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)
4 ETW000 40 0.022058
4 ETW000 [dev trc ,00000] (0.5) DB6: R3load wrong data in tables with STRING columns (note 1226290)
4 ETW000 50 0.022108
4 ETW000 [dev trc ,00000] (0.8) DB6: UR cursor with CC_RELEASE attribute (note 1244963)
4 ETW000 39 0.022147
4 ETW000 [dev trc ,00000] (0.8) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)
4 ETW000 38 0.022185
4 ETW000 [dev trc ,00000] (0.9) R3load: tables with STRING columns part 2 (note 1226290)
4 ETW000 39 0.022224
4 ETW000 [dev trc ,00000] (0.9) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)
4 ETW000 40 0.022264
4 ETW000 [dev trc ,00000] (0.18) DB6: patch collection 11/08 (note 1263885)
4 ETW000 41 0.022305
4 ETW000 [dev trc ,00000] (0.18) DB6: patch collection 11/08 (note 1264825)
4 ETW000 43 0.022348
4 ETW000 [dev trc ,00000] (0.20) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)
4 ETW000 43 0.022391
4 ETW000 [dev trc ,00000] Supported features: 24 0.022415
4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 25 0.022440
4 ETW000 [dev trc ,00000] ..done 114 0.022554
4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 29 0.022583
4 ETW000 [dev trc ,00000] Running with CLI driver 10042 0.032625
4 ETW000 [dev trc ,00000] Tue Oct 9 21:27:18 2012 1600156 1.632781
4 ETW000 [dev trc ,00000] DB2 client driver version '09.05.0007' 34 1.632815
4 ETW000 [dev trc ,00000] Connected to DB2 server type 'DB2/AIX64' 104 1.632919
4 ETW000 [dev trc ,00000] Connected to DB2 version '09.05.0007' 28 1.632947
4 ETW000 [dev trc ,00000] Connect to 'BSX' as 'SAPBSX' schema 'SAPBSX' o.k.; con_hdl=0 ; appl_hdl=184
4 ETW000 1512 1.634459
4 ETW000 [dev trc ,00000] Database code page is ok. 29 1.634488
4 ETW000 [dev trc ,00000] Database collating sequence is ok. 7748 1.642236
4 ETW000 [dev trc ,00000] DB2_WORKLOAD=SAP is set in DB2 registry as required.
4 ETW000 1497 1.643733
4 ETW000 [dev trc ,00000] CLI Insert Buffering is disabled on single partition databases.
4 ETW000 1170 1.644903
4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
4 ETW000 115 1.645018
4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 36 1.645054
4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
4 ETW000 5749 1.650803
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 2256 1.653059
4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.SVERS" is an undefined name. SQ
4 ETW000 39 1.653098
4 ETW000 [dev trc ,00000] &+ LSTATE=42704
4 ETW000 34 1.653132
4 ETW000 [dev trc ,00000] &+
4 ETW000 34 1.653166
4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM SVERS WITH UR
4 ETW000 35 1.653201
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 40 1.653241
4 ETW000 [dev trc ,00000] &+
4 ETW000 35 1.653276
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.653309
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 33 1.653342
4 ETW000 [dblink ,00000] ***LOG BZA=>table SVERS does not exist on database
4 ETW000 47 1.653389
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 782 1.654171
4 ETW000 [dev trc ,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.DDNTT" is an undefined name.
4 ETW000 37 1.654208
4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704
4 ETW000 34 1.654242
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.654275
4 ETW000 [dev trc ,00000] &+ SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 33 1.654308
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 53 1.654361
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.654394
4 ETW000 [dev trc ,00000] &+
4 ETW000 48 1.654442
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 33 1.654475
4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 30 1.654505
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 584 1.655089
4 ETW000 [dev trc ,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.DDNTT" is an undefined name.
4 ETW000 37 1.655126
4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704
4 ETW000 34 1.655160
4 ETW000 [dev trc ,00000] &+
4 ETW000 34 1.655194
4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 34 1.655228
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 39 1.655267
4 ETW000 [dev trc ,00000] &+
4 ETW000 34 1.655301
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.655334
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 33 1.655367
4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 27 1.655394
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 539 1.655933
4 ETW000 [dev trc ,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.DDNTT" is an undefined name.
4 ETW000 35 1.655968
4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704
4 ETW000 34 1.656002
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.656035
4 ETW000 [dev trc ,00000] &+ SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 33 1.656068
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 51 1.656119
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.656152
4 ETW000 [dev trc ,00000] &+
4 ETW000 34 1.656186
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 31 1.656217
4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 36 1.656253
4 ETW000 [dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB
4 ETW000 39 1.656292
4 ETW000 [twdydbacc.c ,00568] i:0 58 1.656350
4 ETW000 [twdydbacc.c ,00569] db_fd_p[i].fname: PGMID 18 1.656368
4 ETW000 [twdydbacc.c ,00570] db_fd_p[i].is_key: 0 16 1.656384
4 ETW000 [twdydbacc.c ,00571] db_fd_p[i].offset: 0 15 1.656399
4 ETW000 [twdydbacc.c ,00572] db_fd_p[i].db_length: 0 16 1.656415
4 ETW000 [twdydbacc.c ,00573] db_fd_p[i].fixed_length:4 15 1.656430
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 514 1.656944
4 ETW000 [dev trc ,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.XXXXT" is an undefined name.
4 ETW000 35 1.656979
4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704
4 ETW000 34 1.657013
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.657046
4 ETW000 [dev trc ,00000] &+ SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 33 1.657079
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 39 1.657118
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.657151
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.657184
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 44 1.657228
4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 45 1.657273
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 476 1.657749
4 ETW000 [dev trc ,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.XXXXT" is an undefined name.
4 ETW000 34 1.657783
4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704
4 ETW000 58 1.657841
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.657874
4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 34 1.657908
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 38 1.657946
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.657979
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.658012
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 32 1.658044
4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 26 1.658070
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)
4 ETW000 489 1.658559
4 ETW000 [dev trc ,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPBSX.XXXXT" is an undefined name.
4 ETW000 35 1.658594
4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704
4 ETW000 34 1.658628
4 ETW000 [dev trc ,00000] &+
4 ETW000 33 1.658661
4 ETW000 [dev trc ,00000] &+ SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 33 1.658694
4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=18, reopt=0
4 ETW000 38 1.658732
4 ETW000 [dev trc ,00000] &+
4 ETW000 44 1.658776
4 ETW000 [dev trc ,00000] &+
4 ETW000 34 1.658810
4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)
4 ETW000 54 1.658864
4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT WHERE TABNAME = 'SVERS' FAILED
4 ETW000 35 1.658899
4 ETW000 [dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB
4 ETW000 37 1.658936
2EETW000 sap_dext called with msgnr "2":
2EETW000 ---- db call info ----
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len (char): 5
2EETW000 key: TADIR
2EETW000 retcode: 2
4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)
4 ETW000
--------------------------------------------------------------------------------------------------------------------------------------------
I know that the schema name of the database schema is still BSD (PRD), but I dont know how to change to BSX (Sandbox) or indicate the correct one.
Thanks in advance.
César Castillo
Hi,
a system copy with backup/restore allows you to change the connect user but not the database schema. So you need to use the old schema from your source database. SAPINST will configure the user environment accordingly.
dbs_db6_schema=<old schema> e.g. sap<sidold>
dbs_db6_user=<new connect user>
Regards
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.