Solved: Source System Copy in SAP on DB2 for AIX 5.3

Hi Team, We have sap systems installed with versions SAP ECC 6.0 on DB2 9.1 for AIX 5.3. so we are going to do the quality system refresh from production system. While doing source system export in PRD (Distributed installation) on central instance - database instance export, it is getting completed successfully. But while checking export files in export location path , ABAP (empty folder) and LABELIDX.ASC files has been created. So no export package files are created during the system export. Please do suggest regarding the same. Thanks and Regards, R Rajavelu

SAP Managed Tags:
IBM Db2 for Linux, UNIX, and Windows

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Raja

1. Are you using the SWPM or Old SAPINST method?

2. Before that could you refer the System copy guide

https://websmp106.sap-ag.de/~sapidb/011000358700001419492012E/systemcopy_70x_ux_abap.pdf

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sriram, Thanks for your reply. 1. Yes, I am using latest SWPM (70SWPM10SP08)for exporting the source system on db2. 2. Same guide I have followed for the same. Please do ask if u need any further detail regarding this. Thanks and Regards, R Rajavelu

Hello Rajavelu,

You have much better option to refresh with backup restore using . redirect restore method,

without any downtime and easy way,

Thanks

Sadiq

Hi, Thanks for your reply. Okay, we can do the database backup restore method using target system installation in Quality. so do we have to uninstall the existing quality server? and reinstall using backup restore of target system installation. Thanks and Regards, R Rajavelu

Hi Raja

If possible do the fresh installation on target system. and the follow the backup /restore method.

Hi Rajevelu

You can do it without un installing,

check the system copy guide for redirect restore,

1- take a latest backup on your source system,

2- generate redirect script on source system

3- Copy redirect script on target system,

4- and run the redirect restore script,

Please fallow it and let us if you have any concern and you need more details.

Thanks

Sadiq

Hi Sadiq,

Okay, I will follow the redirect restore method for quality system refresh as per the guide.

Production database size is around 210 GB and Quality Database size is 176 GB. so do we have to increase the file system size for each data files in QAS ?

Please confirm the same.

Thanks and Regards,

R Rajavelu

Hi Raja

Kindly refer the IBM link and you have to keep the same amount of disk space on target system.

IBM Knowledge Center

Hi Rajavelu

It will be good if you will uses same space as source system.

Thanks

Sadiq

Hi Sriram/Sadiq,

Thanks for reply.

I have one doubt, regarding while executing below script in source system (PRD) :

"db2 restore db test from /home/jseifert/backups taken at 20050304090733 redirect generate script test_node0000.clp".

For above command,can we get generated redirect script file in source system/db2 restore database command will overwrite existing PRD source system db also? Please do clarify the same.

Thanks and Regards,

R Rajavelu

Hello

Use easist way run the below command. No need to modify script

It will automatically convert the SID.

brdb6brt -bm retrieve -s <Source SID> -es -replace <Source SID>=<Target SID>

SID_NODE0000.scr file will get generated

Copy it and run with db2 -tvf filename

Thanks

Sadiq

Hi Sadiq,

As per your reply, I am going to follow the redirect restore method for quality from production.

1- take a latest backup on your source system,

2- generate redirect script on source system

3- Copy redirect script on target system,

4- and run the redirect restore script,

Here, I am not performed installing the target system copy procedure because quality system is already inplace. so please confirm do I missing something here?

Thanks and Regards,

R Rajavelu

Hello Rajavelu,

Make sure you have the user id and password of schema user (source system),

After the restore your target system will user schema user of source system.

Thanks

Sadiq

Hi Sadiq,

Okay. After restore do we have to follow any post activities for troubleshooting ?

As per your instructions, I have generated the redirect script and copied without modifying to the target system(database user and password changed).

Thanks and Regards,

R Rajavelu

Go though the system copy guide and let us know if you get any issue

Thanks

Sadiq

Hi Sadiq,

I need a help from you again, after restore the database using redirect restore method. I am not able to connect/ activate the QAS databse.

Please find the below error for the same.

"SQL1117N A connection to or activation of database "SID" cannot be made

because of ROLL-FORWARD PENDING. SQLSTATE=57019"

and

db2>rollforward db SID query status

Rollforward Status

Input database alias = SID

Number of nodes have returned status = 1

Node number                            = 0
Rollforward status                     = DB working
Next log file to be read               = S0054302.LOG
Log files processed                    = -
Last committed transaction             = 2015-07-06-20.51.03.000000 UTC

Thanks and Regards,

R Rajavelu

Hello

Hope you were able to restore the database successfully?

db2 rollforward db SID to end of logs and stop

Thanks

Sadiq

Hi ,

Thanks for your reply.

I have copied the source system log files into target system log files path, since it online backup restore(include archive logs). Using this command: db2 rollforward db SID to end of logs and stop- database has been rollforward has been sucessfully completed.

While starting sap in SIDADM user, i ma getting this error :ABAP database is not available via R3trans .

Please check and do the needful.

Thanks and Regards,

R Rajavelu

This Not connecting because it is trying to connect with old schema user,

create a schema user same as source system and give the required authorization to it,

db2 grant secadm on database to user db2sid

db2 grant DBADM on database to user db2sid

Note 1285869 - Program MENUSYST: Syntax error or session termination

Note 1386320 - DB6: systemcopy backup / restore - SECADM authority

Also please share the logs w/p and r3trans.

Thanks

Sadiq

Hi Sadiq,

please find the below R3trans log for the same. I have followed this SAP note also 1386320.

cat trans.log

4 ETW000 R3trans version 6.14 (release 700 - 02.05.12 - 15:31:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 08.07.2015 - 15:00:19

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] Wed Jul 8 15:00:19 2015 79 0.000079

4 ETW000 [ dev trc,00000] db_con_init called 31 0.000110

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 43 0.000153

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/RQ1/SYS/exe/run/dbdb6slib.o' ... 48 0.000201

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/RQ1/SYS/exe/run/dbdb6slib.o"), hdl 0

4 ETW000 1502 0.001703

4 ETW000 [ dev trc,00000] Library '/usr/sap/RQ1/SYS/exe/run/dbdb6slib.o' loaded 27 0.001730

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/RQ1/SYS/exe/run/dbdb6slib.o

4 ETW000 41 0.001771

4 ETW000 [ dev trc,00000] Version of '/usr/sap/RQ1/SYS/exe/run/dbdb6slib.o' is "700.08", patchlevel (0.337)

4 ETW000 438 0.002209

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/RQ1/SYS/exe/run/dbdb6slib.o

4 ETW000 39 0.002248

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/RQ1/SYS/exe/run/dbdb6slib.o

4 ETW000 39 0.002287

4 ETW000 [ dev trc,00000] New connection 0 created 37 0.002324

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 62 0.002386

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 35 0.002421

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 24 0.002445

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 60 0.002505

4 ETW000 [ dev trc,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt] 357 0.002862

4 ETW000 [ dev trc,00000] DB6 shared library (dbdb6slib) patchlevels 35 0.002897

4 ETW000 [ dev trc,00000] (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037) 28 0.002925

4 ETW000 [ dev trc,00000] (0.8) Support of SDBUPDEXCL (note 847616) 26 0.002951

4 ETW000 [ dev trc,00000] (0.9) DB6: use export file for dbdb6slib (note 835135) 26 0.002977

4 ETW000 [ dev trc,00000] (0.9) DB6: Core in getAndBindSQLDA (note 833183) 26 0.003003

4 ETW000 [ dev trc,00000] (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000 40 0.003043

4 ETW000 [ dev trc,00000] (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474) 34 0.003077

4 ETW000 [ dev trc,00000] (0.15) DB6: wrong CAST for short string ABAP type (note 861905) 27 0.003104

4 ETW000 [ dev trc,00000] (0.17) DB6: special characters in sidadm passwd (note 865839) 26 0.003130

4 ETW000 [ dev trc,00000] (0.21) DB6: no SAP_INFO comments (note 873889) 32 0.003162

4 ETW000 [ dev trc,00000] (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 41 0.003203

4 ETW000 [ dev trc,00000] (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 39 0.003242

4 ETW000 [ dev trc,00000] (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402) 26 0.003268

4 ETW000 [ dev trc,00000] (0.27) DB6: activate value compression (note 886231) 26 0.003294

4 ETW000 [ dev trc,00000] (0.28) DB6: optimization guidelines on views part 2 (note 868888) 27 0.003321

4 ETW000 [ dev trc,00000] (0.30) DB6: no SQL trace for SQLCancel (note 892111) 26 0.003347

4 ETW000 [ dev trc,00000] (0.33) DB6: append SAP_TA comment (note 873889) 26 0.003373

4 ETW000 [ dev trc,00000] (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000 45 0.003418

4 ETW000 [ dev trc,00000] (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000 40 0.003458

4 ETW000 [ dev trc,00000] (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000 39 0.003497

4 ETW000 [ dev trc,00000] (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000 40 0.003537

4 ETW000 [ dev trc,00000] (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000 39 0.003576

4 ETW000 [ dev trc,00000] (0.54) DB6: error handling in DBSL CLP (note 940260) 26 0.003602

4 ETW000 [ dev trc,00000] (0.69) DB6: technical support of DB2 CLI driver (note 962892) 26 0.003628

4 ETW000 [ dev trc,00000] (0.73) DB6: log table name on TRUNCATE failure (note 970743) 27 0.003655

4 ETW000 [ dev trc,00000] (0.79) DB6: column type XML in index size calculation (note 982993)

4 ETW000 39 0.003694

4 ETW000 [ dev trc,00000] (0.82) DB6: CAST for SSTRING data types (note 989568) 26 0.003720

4 ETW000 [ dev trc,00000] (0.86) DB6: long runtimes for R3szchk (note 1000847) 26 0.003746

4 ETW000 [ dev trc,00000] (0.88) DB6: patch collection Dec 06 (note 1005574) 27 0.003773

4 ETW000 [ dev trc,00000] (0.96) DB6: patch collection Jan 07 (note 1017852) 26 0.003799

4 ETW000 [ dev trc,00000] (0.97) DB6: CLP commands with DB2 CLI Driver (note 1024102) 26 0.003825

4 ETW000 [ dev trc,00000] (0.99) DB6: SUBSTITUTE VALUES with FAE statements (note 1028779) 27 0.003852

4 ETW000 [ dev trc,00000] (0.107) DB6: patch collection Apr 07 (note 1047194) 32 0.003884

4 ETW000 [ dev trc,00000] (0.110) DB6: SAP user names ending with non-ASCII char (note 1054555)

4 ETW000 46 0.003930

4 ETW000 [ dev trc,00000] (0.113) DB6: work process type in application snapshot (note 1059905)

4 ETW000 40 0.003970

4 ETW000 [ dev trc,00000] (0.114) DB6: connect using SAPDBHOST and DB2DB6_SVCENAME (note 1062049)

4 ETW000 40 0.004010

4 ETW000 [ dev trc,00000] (0.117) DB6: patch for execution of long DDL statements (note 1069658)

4 ETW000 39 0.004049

4 ETW000 [ dev trc,00000] (0.122) DB6: SNAPSHOT_TBS_CFG table function is deprecated (note 1077963)

4 ETW000 40 0.004089

4 ETW000 [ dev trc,00000] (0.123) DB6: CLP commands on Windows with V9.1 (note 1080149) 26 0.004115

4 ETW000 [ dev trc,00000] (0.124) DB6: Set DB2CODEPAGE=819 for non-Unicode (note 1084400) 27 0.004142

4 ETW000 [ dev trc,00000] (0.126) DB6: reuse optguidelines on FAE statements (note 1087375) 27 0.004169

4 ETW000 [ dev trc,00000] (0.126) DB6: Enforce DB2CODEPAGE=819 for non-Unicode environments (note 1084400)

4 ETW000 40 0.004209

4 ETW000 [ dev trc,00000] (0.128) DB6: db6_free on invalid memory area (note 1092030) 26 0.004235

4 ETW000 [ dev trc,00000] (0.133) DB6: statement cache enhancements (note 1101031) 27 0.004262

4 ETW000 [ dev trc,00000] (0.136) DB6: change for enhancement pack installer (note 1111536) 26 0.004288

4 ETW000 [ dev trc,00000] (0.138) DB6: improoved table size estimate for DB8 V8 (note 1119934)

4 ETW000 40 0.004328

4 ETW000 [ dev trc,00000] (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

4 ETW000 39 0.004367

4 ETW000 [ dev trc,00000] (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

4 ETW000 45 0.004412

4 ETW000 [ dev trc,00000] (0.148) DB6: allocate new CLI env handle if PID changes (note 1141570)

4 ETW000 40 0.004452

4 ETW000 [ dev trc,00000] (0.150) DB6: USE AND KEEP EXCLUSIVE LOCKS clause lost (note 1145580)

4 ETW000 39 0.004491

4 ETW000 [ dev trc,00000] (0.151) DB6: projection views on virtual tables (note 1146142) 27 0.004518

4 ETW000 [ dev trc,00000] (0.152) Corrections of odbc-based dbsl (note 1135165) 26 0.004544

4 ETW000 [ dev trc,00000] (0.156) "DB6: TRUNCATE on table with DELETE triggers" (note 1156597)

4 ETW000 40 0.004584

4 ETW000 [ dev trc,00000] (0.164) DB6: patch collection 06/08 (note 1172220) 26 0.004610

4 ETW000 [ dev trc,00000] (0.167) DB2 - z/OS: performance improvement for long running LUWs (note 1179742)

4 ETW000 40 0.004650

4 ETW000 [ dev trc,00000] (0.171) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030) 32 0.004682

4 ETW000 [ dev trc,00000] (0.176) DB6: UR cursor with CC_RELEASE attribute (note 1244963) 27 0.004709

4 ETW000 [ dev trc,00000] (0.176) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 46 0.004755

4 ETW000 [ dev trc,00000] (0.178) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 40 0.004795

4 ETW000 [ dev trc,00000] (0.185) DB6: patch collection 11/08 (note 1263885) 26 0.004821

4 ETW000 [ dev trc,00000] (0.185) DB6: patch collection 11/08 (note 1264825) 26 0.004847

4 ETW000 [ dev trc,00000] (0.186) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 41 0.004888

4 ETW000 [ dev trc,00000] (0.198) DB6: patch collection 02/09 (note 1294443) 32 0.004920

4 ETW000 [ dev trc,00000] (0.201) DB6: cobra enhancements (note 1315762) 27 0.004947

4 ETW000 [ dev trc,00000] (0.204) Sapinst on windows/maxdb stop with error (note 1323436) 26 0.004973

4 ETW000 [ dev trc,00000] (0.204) DB6: configurable cc_release attribute for UR cursors (note 1324532)

4 ETW000 40 0.005013

4 ETW000 [ dev trc,00000] (0.205) DB6: unexpected token INLINE LENGTH (note 1334179) 26 0.005039

4 ETW000 [ dev trc,00000] (0.206) DB6: cobra enhancements part 2 (note 1315762) 27 0.005066

4 ETW000 [ dev trc,00000] (0.212) DB6: substitution of aliases in optguidelines (note 1352458)

4 ETW000 39 0.005105

4 ETW000 [ dev trc,00000] (0.217) DB6: login timeout for secondary connections (note 1364372)

4 ETW000 39 0.005144

4 ETW000 [ dev trc,00000] (0.221) DB6: revalidate views in status active=N (note 1376439) 32 0.005176

4 ETW000 [ dev trc,00000] (0.221) DB6: create index with 9.7 and virtual tables (note 1371882)

4 ETW000 40 0.005216

4 ETW000 [ dev trc,00000] (0.222) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

4 ETW000 40 0.005256

4 ETW000 [ dev trc,00000] (0.223) DB6: table function SNAPSHOT_LOCKWAIT in db6util (note 1383921)

4 ETW000 40 0.005296

4 ETW000 [ dev trc,00000] (0.225) DB6: timeout for CREATE/DROP TRIGGER (note 1387865) 26 0.005322

4 ETW000 [ dev trc,00000] (0.229) DB6: patch collection 10/09 (note 1397804) 26 0.005348

4 ETW000 [ dev trc,00000] (0.232) DB6: Potentially unnoticed rollback during array operation (note 1406740)

4 ETW000 40 0.005388

4 ETW000 [ dev trc,00000] (0.237) DB6: client affinity support (note 1414616) 32 0.005420

4 ETW000 [ dev trc,00000] (0.239) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

4 ETW000 41 0.005461

4 ETW000 [ dev trc,00000] (0.247) DB6: patch collection 03/10 (note 1447436) 26 0.005487

4 ETW000 [ dev trc,00000] (0.257) DB6: patch collection 05/10 (note 1364372) 26 0.005513

4 ETW000 [ dev trc,00000] (0.257) DB6: patch collection 05/10 (note 1470824) 33 0.005546

4 ETW000 [ dev trc,00000] (0.259) DB6: return original schema in shadow system (note 1474361)

4 ETW000 40 0.005586

4 ETW000 [ dev trc,00000] (0.261) DB6: literals for decimal columns of value 0 (note 1482790)

4 ETW000 39 0.005625

4 ETW000 [ dev trc,00000] (0.261) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000 40 0.005665

4 ETW000 [ dev trc,00000] (0.264) DB6: tolerate client deletes on virtual tables (note 1484286)

4 ETW000 46 0.005711

4 ETW000 [ dev trc,00000] (0.272) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

4 ETW000 39 0.005750

4 ETW000 [ dev trc,00000] (0.273) DB6: revalidation of view failed (note 1376439) 26 0.005776

4 ETW000 [ dev trc,00000] (0.274) DB6: DROP INDEX on virtual table ignored (note 1514380) 27 0.005803

4 ETW000 [ dev trc,00000] (0.277) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

4 ETW000 40 0.005843

4 ETW000 [ dev trc,00000] (0.279) DB6: SQL0301N after LONG to LOB conversion (note 1524339) 29 0.005872

4 ETW000 [ dev trc,00000] (0.294) DB6: patch collection 03/11 (note 1568512) 26 0.005898

4 ETW000 [ dev trc,00000] (0.297) DB6: REORG table causes SQL0108 (note 1575617) 26 0.005924

4 ETW000 [ dev trc,00000] (0.302) DB6: FOR ALL ENTRIES with SUBSTITUTE VALUES (note 1587338)

4 ETW000 39 0.005963

4 ETW000 [ dev trc,00000] (0.320) DB6: refresh connection infos on seamless failover (note 1629682)

4 ETW000 40 0.006003

4 ETW000 [ dev trc,00000] (0.327) DB6: Galileo patch collection (note 1649831) 26 0.006029

4 ETW000 [ dev trc,00000] (0.337) DB6: isolation RS for select in INDX type cluster tables (note 1678935)

4 ETW000 40 0.006069

4 ETW000 [ dev trc,00000] Supported features: 24 0.006093

4 ETW000 [ dev trc,00000] ..retrieving configuration parameters 28 0.006121

4 ETW000 [ dev trc,00000] ..done 143 0.006264

4 ETW000 [ dev trc,00000] DB2 library successfully loaded DB2 library '/db2/db2rq1/sqllib/lib64/libdb2.a(shr_64.o)' successfully loaded

4 ETW000 7125 0.013389

4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode 25 0.013414

4 ETW000 [ dev trc,00000] Running with CLI runtime client libraries. 20146 0.033560

4 ETW000 [ dev trc,00000] Wed Jul 8 15:00:21 2015 2286705 2.320265

4 ETW000 [ dev trc,00000] DB2 client driver version '09.01.0002' 32 2.320297

4 ETW000 [ dev trc,00000] Connected to DB server type 'DB2/AIX64' 73 2.320370

4 ETW000 [ dev trc,00000] Connected to DB server version '09.01.0002' 42 2.320412

4 ETW000 [ dev trc,00000] Connected to 'RQ1' as 'SAPRQ1' schema 'SAPRQ1' o.k. 42011 2.362423

4 ETW000 [ dev trc,00000] Connected: con_hdl=0 ; appl_hdl=11; appl_id="*LOCAL.db2rq1.150708093021"

4 ETW000 51 2.362474

4 ETW000 [ dev trc,00000] Database code page is ok. 28 2.362502

4 ETW000 [ dev trc,00000] Database collating sequence is ok. 108337 2.470839

4 ETW000 [ dev trc,00000] DB2_WORKLOAD=SAP is set in DB2 registry as required. 23409 2.494248

4 ETW000 [ dev trc,00000] CLI Insert Buffering is disabled on single partition databases. 21214 2.515462

4 ETW000 [ dev trc,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 89 2.515551

4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 27 2.515578

4 ETW000 [ dev trc,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 7011 2.522589

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 1146 2.523735

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.SVERS" is an undefined name. SQ

4 ETW000 52 2.523787

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 43 2.523830

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.523872

4 ETW000 [ dev trc,00000] &+ SELECT VERSION FROM SVERS WITH UR

4 ETW000 43 2.523915

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

4 ETW000 46 2.523961

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.524004

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.524047

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.524073

4 ETW000 [ dblink ,01301] ***LOG BZA=>table SVERS does not exist on database [dblink#8 @ 1301]

4 ETW000 53 2.524126

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 525 2.524651

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.DDNTT" is an undefined name. SQ

4 ETW000 50 2.524701

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 52 2.524753

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.524796

4 ETW000 [ dev trc,00000] &+ SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 43 2.524839

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

4 ETW000 52 2.524891

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.524934

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.524977

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.525003

4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 39 2.525042

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 299 2.525341

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.DDNTT" is an undefined name. SQ

4 ETW000 48 2.525389

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 43 2.525432

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.525475

4 ETW000 [ dev trc,00000] &+ SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 42 2.525517

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

4 ETW000 45 2.525562

4 ETW000 [ dev trc,00000] &+

4 ETW000 44 2.525606

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.525648

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.525674

4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 47 2.525721

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 285 2.526006

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.DDNTT" is an undefined name. SQ

4 ETW000 48 2.526054

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 43 2.526097

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.526139

4 ETW000 [ dev trc,00000] &+ SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 43 2.526182

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

4 ETW000 46 2.526228

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.526271

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.526313

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.526339

4 ETW000 [ dbntab.c,00000] *** ERROR => NTAB: SELECT DBASE FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 43 2.526382

4 ETW000 [ dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#12 @ 12739]

4 ETW000 48 2.526430

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 392 2.526822

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.XXXXT" is an undefined name. SQ

4 ETW000 49 2.526871

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 43 2.526914

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.526957

4 ETW000 [ dev trc,00000] &+ SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 43 2.527000

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

4 ETW000 54 2.527054

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.527097

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.527139

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.527165

4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 40 2.527205

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 293 2.527498

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.XXXXT" is an undefined name. SQ

4 ETW000 48 2.527546

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 43 2.527589

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.527631

4 ETW000 [ dev trc,00000] &+ SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 43 2.527674

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

4 ETW000 45 2.527719

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.527762

4 ETW000 [ dev trc,00000] &+

4 ETW000 43 2.527805

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.527831

4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 39 2.527870

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] CON = 0 (BEGIN) 281 2.528151

4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/AIX64] SQL0204N "SAPRQ1.XXXXT" is an undefined name. SQ

4 ETW000 47 2.528198

4 ETW000 [ dev trc,00000] &+ LSTATE=42704

4 ETW000 50 2.528248

4 ETW000 [ dev trc,00000] &+

4 ETW000 44 2.528292

4 ETW000 [ dev trc,00000] &+ SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 44 2.528336

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

4 ETW000 45 2.528381

4 ETW000 [ dev trc,00000] &+

4 ETW000 44 2.528425

4 ETW000 [ dev trc,00000] &+

4 ETW000 42 2.528467

4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[dbdb6.c, 13994] (END) 26 2.528493

4 ETW000 [ dbntab.c,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 43 2.528536

4 ETW000 [ dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#12 @ 12739]

4 ETW000 46 2.528582

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) 349 2.528931

Thanks and Regards,

R Rajavelu

Answers (1)

Hi Team,

The issue has been resolved and I have followed the database redirect restore method.

Thanks to Sadiq and Sriram for their suggesstions.

Thanks and Regards,

R Rajavelu

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Raja

This is really good to hear ,

Please share the solution that will help to others,

Now do post activity . below link will give you idea,

Thanks

Sadiq

Message was edited by: Sadiq Iqbal

Ask a Question

Top Q&A Solution Author

User

Count

Source System Copy in SAP on DB2 for AIX 5.3

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

Retreiving AppGyver project

What is the difference between OMS and OMM, while ...

Re: Incorporate international clients into VAR Chi...

Incorporate international clients into VAR Chile

Re: reading external (OData) API from cap