Error - R3trans -

[Former Member]

Hello Experts,

We are not able to start the SAP system (ABAP+JAVA) after a database upgrade.

We had database backup data of system during DB2 v9.1 and we installed a system with database version 9.5 FP4.

We then restored the database and migrated the data to 9.5 FP4

Since the data of /usr/sap/<SID> ; and /sapmnt/<SID> was corrupted, we had to go for a restore of the data from backup which was taken during the time when the system was running DB2 9.1 . Therefor we had to upgrade the DB2 Client.

After the client upgrade we are no more getting the database and client version mismatch. How Ever the R3trans is giving the below error:

4 ETW000  [     dev trc,00000]  Supported features:                                                       49  0.006487

4 ETW000  [     dev trc,00000]  ..retrieving configuration parameters                                     45  0.006532

4 ETW000  [     dev trc,00000]  ..done                                                                   194  0.006726

4 ETW000  [     dev trc,00000]  DB2 library has been loaded.                                            4965  0.011691

4 ETW000  [     dev trc,00000]  Info: successfully loaded DB2 library '/usr/sap/C71/SYS/global/db6/AIX_64/db6_clidriver/lib/libdb2.a(shr_64.o)'

4 ETW000                                                                                                  67  0.011758

4 ETW000  [     dev trc,00000]  Running with UTF-8 Unicode                                                41  0.011799

4 ETW000  [     dev trc,00000]  DB2 client driver version '09.05.0004'                                   755  0.012554

4 ETW000  [     dev trc,00000]  Running with CLI driver.                                                5700  0.018254

4 ETW000  [     dev trc,00000]  Sun Dec  8 23:40:44 2013                                             1500280  1.518534

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

4 ETW000  [     dev trc,00000]  Connected to DB server version '09.05.0004'                               49  1.518620

4 ETW000  [     dev trc,00000]  Connected to 'C71' as 'SAPC71' schema 'SAPC71' o.k.                     1159  1.519779

4 ETW000  [     dev trc,00000]  Connected: con_hdl=0 ; appl_hdl=13; appl_id="9.126.40.83.59264.131209054044"

4 ETW000                                                                                                  65  1.519844

4 ETW000  [     dev trc,00000]  Database code page is ok.                                                 46  1.519890

4 ETW000  [     dev trc,00000]  Database collating sequence is ok.                                      7601  1.527491

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

4 ETW000  [     dev trc,00000]  Optimizer profile table does not exist.                                  868  1.529508

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

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

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)                                       46  1.530375

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

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Fetch[dbdb6.c, 3995] CON = 0 (BEGIN)                    1994  1.543134

4 ETW000  [     dev trc,00000]  &+     DbSlReadDB6( SQLFetch 😞 [IBM][CLI Driver][DB2/AIX64] SQL0290N  Table space access is not allowed.  SQLSTATE=55039

4 ETW000                                                                                                  71  1.543205

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  67  1.543272

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  67  1.543339

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

4 ETW000                                                                                                  67  1.543406

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

4 ETW000                                                                                                  91  1.543497

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  67  1.543564

4 ETW000  [     dev trc,00000]  &+     Output SQLDA:

4 ETW000                                                                                                  67  1.543631

4 ETW000  [     dev trc,00000]  &+                        1 CT=WCHAR           T=VARCHAR         L=144   P=216   S=0

4 ETW000                                                                                                  85  1.543716

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  68  1.543784

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  66  1.543850

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Fetch[dbdb6.c, 3995] (END)                                46  1.543896

4 ETW000  [    dblink  ,00000]  ***LOG BZA=>table SVERS      does not exist on database                  193  1.544089

Please help us analyse the issue and resolve the same.

[Former Member]

Hello,

Could you explain the correct sequence of tasks you did, what you posted is quite confusing. Verify all the environment variables (seriously) and then passwords as well (using dscdb6up).

[Former Member]

Hello Avinash,

Check the below link.. It talks about the same issue

http://scn.sap.com/thread/2122869

Mudasir

[Former Member]

Hello Avinahs,

can you please attach the output of

db2 get snapshot for tablespaces on <SID>

regards,
Javier

[hugo_amo]

Hi Avinash,

It looks as if some table space is not in a correct state. Paste here the output of :

db2 list tablespaces show detail

Regards,

Hugo