Skip to Content
0
Former Member
Oct 10, 2012 at 03:46 AM

DB2 Redirected Restore NW AS ABAP

165 Views

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