cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

R3trans -dvw problems with TADIR access system copy

msdra
Explorer
0 Kudos

Hello Everyone,


We performed a system copy, and we performed change of schema from old source SID to new source SID. We were able to establish a connection using db2 connect to <new source SID> user sap<new source SID> using Master4SID

, and we performed vi edit in dbenv files and upon updating schema connection using select CON_ENV, user_name from sap<new source SID>.dbcon and Update dbcon user from SOURCE TO TARGET, we are getting errors below:


DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "SAPSID.DBCON" is an undefined name. SQLSTATE=42704


SQL0204N "SAPSSID.DBCON" is an undefined name. SQLSTATE=42704


and we found this in trans.log

hostname:SIDadm 53> R3trans -d
This is R3trans version 6.26 (release 753 - 23.04.19 - 20:19:01).
unicode enabled version
2EETW000 I have some problems during TADIR access.
1AETW000 ERROR: first character of SAP-Release is not a digit, but '
2EETW000 Please contact the SAP support.
exiting ...
R3trans finished (0016).
usarpalpqassl01:SIDadm 54> cat trans.log
4 ETW000 R3trans version 6.26 (release 753 - 23.04.19 - 20:19:01).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 02.09.2023 - 18:40:08
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Sat Sep 2 18:40:08 2023
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/SID/SYS/exe/run/dbdb6slib.so' ...
4 ETW000 [ dev trc,00000] Library '/usr/sap/SID/SYS/exe/run/dbdb6slib.so' loaded
4 ETW000 [ dev trc,00000] Version of '/usr/sap/SID/SYS/exe/run/dbdb6slib.so' is "753.02", patchlevel (0 .500)
4 ETW000 [ dev trc,00000] RLIMIT_STACK: current=8388608, max=-1
4 ETW000 [ dev trc,00000] DB6 (DB2 UDB) UNICODE database interface 753.02 [opt]
4 ETW000 [ dev trc,00000] DB6 shared library (dbdb6slib) patchlevels
4 ETW000 [ dev trc,00000] (0.15) DB6: Performance problem with LIMIT 1 queries (note 2518579)
4 ETW000 [ dev trc,00000] (0.21) DB6: call out script to collect support data after SQL exceptions (n ote 2535913)
4 ETW000 [ dev trc,00000] (0.31) DB6: disable FDA on non unicode databases (note 2569604)
4 ETW000 [ dev trc,00000] (0.31) DB6: error handling on connection attempts without password (note 25 50653)
4 ETW000 [ dev trc,00000] (0.33) DB6: indirect hints for FOR ALL ENTRIES statements using FDA (note 2 575792)
4 ETW000 [ dev trc,00000] (0.90) DB4: SQL-913 Locks on SQL Packages in the 749 Kernel (note 2581617)
4 ETW000 [ dev trc,00000] (0.100) SAP Support Package Stack Kernel 7.53 Patch Level 100 (note 2608318 )
4 ETW000 [ dev trc,00000] (0.110) DB6: FDA with overly large input data (note 2600815)
4 ETW000 [ dev trc,00000] (0.110) DB6: cumulative DBSL trace records lost on disconnect of secondary con (note 2587614)
4 ETW000 [ dev trc,00000] (0.110) DB6: incorrect member number in network statistics (note 2594089)
4 ETW000 [ dev trc,00000] (0.110) DB6: retry isolated DDL after sqlcode -911 (note 2602488)
4 ETW000 [ dev trc,00000] (0.110) DB6: statement string is blank or empty (note 2602538)
4 ETW000 [ dev trc,00000] (0.111) DB6: OPTGUIDELINES may not be parsed correctly (note 2624355)
4 ETW000 [ dev trc,00000] (0.200) SAP Support Package Stack Kernel 7.53 Patch Level 200 (note 2637769 )
4 ETW000 [ dev trc,00000] (0.201) SAP Support Package Stack Kernel 7.53 Patch Level 201 (note 2650112 )
4 ETW000 [ dev trc,00000] (0.210) DB6: hint FAE_JOIN_BLOCKING_WITH_DISTINCT (note 2627423)
4 ETW000 [ dev trc,00000] (0.213) DB6: better handling of cancel requests during connect processing ( note 2652633)
4 ETW000 [ dev trc,00000] (0.221) DB6: no DB error message was returned on MOD (note 2677032)
4 ETW000 [ dev trc,00000] (0.221) DB6: use explicit GROUP BY for FOR ALL ENTRIES with FDA (note 26752 36)
4 ETW000 [ dev trc,00000] (0.224) DB6: Explain with invalid statement text may cause work process abo rt (note 2684700)
4 ETW000 [ dev trc,00000] (0.226) DB6: runtime error DBSQL_DBCNT_MISSMATCH on DELETE on virtual table (note 2693826)
4 ETW000 [ dev trc,00000] (0.300) SAP Support Package Stack Kernel 7.53 Patch Level 300 (note 2699298 )
4 ETW000 [ dev trc,00000] (0.310) DB6: MEMORY_TABLE_CARDINALITY optimizer profile (note 2700223)
4 ETW000 [ dev trc,00000] (0.310) DB6: make dbsl_iuuc_end_transaction_hook dynamic (note 2700555)
4 ETW000 [ dev trc,00000] (0.315) DB6: Bad Isolation Level for IUD Statement with Subselect (note 272 3644)
4 ETW000 [ dev trc,00000] (0.400) SAP Support Package Stack Kernel 7.53 Patch Level 400 (note 2752112 )
4 ETW000 [ dev trc,00000] (0.400) DB6: Secondary connections from Linux PPC LE application server (no te 2751541)
4 ETW000 [ dev trc,00000] (0.401) SAP Support Package Stack Kernel 7.53 Patch Level 401 (note 2800986 )
4 ETW000 [ dev trc,00000] (0.410) DB6: Default isolation CS for inline compound SQL statements (note 2756198)
4 ETW000 [ dev trc,00000] (0.410) DB6: Default isolation for directly executed statements (note 27627 81)
4 ETW000 [ dev trc,00000] (0.410) DB6: FOR ALL ENTRIES with SSTRING data type (note 2747477)
4 ETW000 [ dev trc,00000] (0.410) DB6: SQL1476N error -803 on ABAP INSERT FROM TABLE statement (note 2745432)
4 ETW000 [ dev trc,00000] (0.413) DB6: on PureScale TRUNCATE TABLE may be blocked by BACKUP (note 277 2896)
4 ETW000 [ dev trc,00000] (0.420) DB6: generic user SAPSYS in CURRENT CLIENT_USERID (note 2791331)
4 ETW000 [ dev trc,00000] (0.424) DB6: correlation name for table name in optimizer guideline not fou nd (note 2809307)
4 ETW000 [ dev trc,00000] (0.500) SAP Support Package Stack Kernel 7.53 Patch Level 500 (note 2822875 )
4 ETW000 [ dev trc,00000] Supported features:
4 ETW000 [ dev trc,00000] ..retrieving configuration parameters
4 ETW000 [ dev trc,00000] ..done
4 ETW000 [ dev trc,00000] DB2 library has been loaded.
4 ETW000 [ dev trc,00000] Info: successfully loaded DB2 library '/usr/sap/SID/SYS/global/db6/LINUXX86_6 4/db6_clidriver/lib/libdb2.so'
4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode
4 ETW000 [ dev trc,00000] DB2 client driver version '11.01.0406'
4 ETW000 [ dev trc,00000] Running with CLI driver.
4 ETW000 [ dev trc,00000] Sat Sep 2 18:40:09 2023
4 ETW000 [ dev trc,00000] CLI cfg for con_hdl=0:
4 ETW000 [ dev trc,00000] DSN="SID";UID="sapnewsourceSID";DATABASE=SID;PROTOCOL=TCPIP;HOSTNAME=arpdbSID;SERVICEN AME=5932;
4 ETW000 [ dev trc,00000] Connected to DB server type 'DB2/LINUXX8664'
4 ETW000 [ dev trc,00000] Connected to DB server version '11.01.0406'
4 ETW000 [ dev trc,00000] Connected to 'SID' as 'SAPnewsourceSID' schema 'SAPnewsourceSID' o.k.
4 ETW000 [ dev trc,00000] Connected: con_hdl=0 ; appl_hdl=998; appl_id="160.222.250.225.64866.230902224 009"
4 ETW000 [ dev trc,00000] Current member="160.222.250.73:5932"
4 ETW000 [ dev trc,00000] Database code page is ok.
4 ETW000 [ dev trc,00000] Database collating sequence is ok.
4 ETW000 [ dev trc,00000] DB2_WORKLOAD=SAP is set in DB2 registry as required.
4 ETW000 [ dev trc,00000] Optimizer profile table does not exist.
4 ETW000 [ dev trc,00000] CLI Insert Buffering is disabled on single partition databases.
4 ETW000 [ dev trc,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0)
4 ETW000 [ dev trc,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] CON = 0 CACHEID = 5 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlReadDB6( SQLExtendedPrepare ๐Ÿ˜ž [IBM][CLI Driver][DB2/LINUXX8664] S QL0204N "SAPnewsourceSID.SVERS" is an undefined name
4 ETW000 [ dev trc,00000] &+ . SQLSTATE=42704
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+ SELECT VERSION FROM SVERS WITH UR
4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degre e=1, op_type=18, read_only=1
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] (END)
4 ETW000 [ dblink ,00000] ***LOG BZA=>table SVERS does not exist on database
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] CON = 0 CACHEID = 6 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare ๐Ÿ˜ž [IBM][CLI Driver][DB2/LINUXX8664 ] SQL0204N "SAPnewsourceSID.DDNTT" is an undefined n
4 ETW000 [ dev trc,00000] &+ ame. SQLSTATE=42704
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+ SELECT * FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degre e=1, op_type=18, read_only=1
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] (END)
4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: get_ntab_db_structure(): ddntt_column_check() returned dbs l error 103
4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 4
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] CON = 0 CACHEID = 7 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare ๐Ÿ˜ž [IBM][CLI Driver][DB2/LINUXX8664 ] SQL0204N "SAPnewsourceSID.XXXXT" is an undefined n
4 ETW000 [ dev trc,00000] &+ ame. SQLSTATE=42704
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+ SELECT * FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degre e=1, op_type=18, read_only=1
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] (END)
4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: get_ntab_db_structure(): ddntt_column_check() returned dbs l error 103
4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 4
4 ETW000 [ dev trc,00000] *** ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15004] CON = 0 CACHEID = 8 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlBegReadDB6( SQLExtendedPrepare ๐Ÿ˜ž [IBM][CLI Driver][DB2/LINUXX8664 ] SQL0204N "SAPnewsourceSID.XXXXT" is an undefined n
4 ETW000 [ dev trc,00000] &+ ame. SQLSTATE=42704
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+ SELECT * FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR
4 ETW000 [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degre e=1, op_type=18, read_only=1
4 ETW000 [ dev trc,00000] &+

Kindly requesting your assistance on what checks do we need to perform or we may have overlooked something. Thank you in advance










Accepted Solutions (1)

Accepted Solutions (1)

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Maria,
Please check your environment settings for variable dbs_db6_user and dbs_db6_schema .

In the database please check to following statements to see which schema contains your SAP tables.
dbs_db6_schema must be set to this schema.

db2 " select count(*), tabschema from syscat.tables group by tabschema "
db2 " select tabschema from syscat.tables where tabname = 'SVERS' "

Regards
Frank

Answers (0)