Skip to Content
avatar image
Former Member

Not able to View Tablespaces from DB02 in DB2 system

Hello All,

There was a System refresh done on one of our QAS system and it was done using backup / Restore method.. Now the Target DB i.e QAS is up and running, How ever when i go to DB02 and click on table spaces it comes back with an error like this and i dont see any tables under tablespace name. Has any one seen this earlier ??????

DB Error: Yes

SQL Code: 443-

SQL Message: SQL0443N Routine "SNAPSHOT_DBM" (specific name "SNAPSHOT_DBM") has returned an error SQLSTATE with diagnostic text "SQL1092 Reason code or token: SAPPRD ". SQLSTATE=38553

Regards,

Ershad Ahmed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 08, 2008 at 01:31 PM

    Hi ,

    please check SAP Note 956214 .

    Is SAP Connect user "SAPPRD" member of SYSMAINT_GROUP DB<DBSID>MNT Group on Database Server ?

    Best regards

    dirk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      you should create SAPPRD user and assign it to SYSMAINT_GROUP DB<DBSID>MNT Group, try it again , i think it can resolve your issue.

  • Oct 08, 2008 at 05:47 AM

    Hi.

    If you have seen tablespaces before the restore you are definitely not using DB2 on IBM i. This database has no tablespaces.

    If you give us the information which database you are using I can move your question to a more appropriate forum.

    Best regards,

    Jan Stallkamp

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 05:54 AM

    Hello Jan,

    We are using DB2 on AIX 5.3 and there were tablespaces before the resrtore, but after refresh i cannot view them from DB02 . I hope this is sufficient info

    db2 connect to QAS

    Database Connection Information

    Database server = DB2/AIX64 9.1.3

    SQL authorization ID = DB2QAS

    Local database alias = QAS

    Regards,

    Ershad Ahmed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2008 at 04:18 AM

    Hello Dirk and Tony,

    Thanks for ur reply the Issue has been resolved after i followed the SAP note that was mentioned by Dirk. Thanks once again

    Regards,

    Ershad Ahmed

    Add comment
    10|10000 characters needed characters exceeded

    • Even though this an older post, I'd like to adress a similiar situation we have here:

      Calling TA db6cockpit will lead to syslog entries like:

      DB6C BY1 Datenbankfehler -443 aufgetreten

      DB6C BY2 Datenbankfehler -443 beim FET aufgetreten

      DB6C BY0 > SQL0443N Routine "SNAPSHOT_DBM" (specific name

      DB6C BY0 > "SNAPSHOT_DBM") has returned an error SQLSTATE with

      DB6C BY0 > diagnostic text "SQL1092 Reason code or token: SAPR3 ".

      DB6C BY0 > SQLSTATE=38553

      Already checked

      Hinweis 955517 - Begrenzung d. Anzahl d. v. DB2 verbreiteten db2fmp-Prozesse

      which seems set as supposed

      &

      Hinweis 956214 - DB6: SQL0443N nach Upgrade auf neues SAP-Release

      The error is caused by the missing user group DB<DBSID>MNT, or the SCHEMA USER (SAP<DBSID>,SAPR3) is not added to group DB<DBSID>MNT

      As we do not run DB2 on *NIX but on WIN, we can't adjust the schema owner SAPR3 to become a group member like that.