Database can't be accessed after restore

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • seanlei
    New Member
    • Oct 2012
    • 1

    Database can't be accessed after restore

    The redirect restore success. But can't connect to it and get the following error:

    $ db2 connect to dwmm
    SQL0332N Character conversion from the source code page "1386" to the target
    code page "819" is not supported. SQLSTATE=57017


    I can check the db cfg:

    Database territory = CN
    Database code page = 1386
    Database code set = GBK
    Database country/region code = 86
    Database collating sequence = UNIQUE

    So I set the codepage:
    db2set DB2CODEPAGE=138 6

    Then I can connect to the database.
    $ db2 connect to dwmm

    Database Connection Information

    Database server = DB2/AIX64 9.7.6
    SQL authorization ID = DB2IST01
    Local database alias = DWMM


    But I can't do anything against the db:
    $ db2 "list tables"
    SQL0805N Package "NULLID.SQLC2H2 3 0X4141414141424 263" was not found.
    SQLSTATE=51002
    $ db2 "get db cfg for dwmm"
    SQL4707N The workload named "SYSDEFAULTUSER WORKLOAD" cannot service the
    request because the workload is not allowed to access the database.
    SQLSTATE=5U020


    Any comment will be appreciated.
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    You can't do anything with the tables because I don't think there is anything there to actually work with - the conversion failed: SQL0332N - Detail

    Comment

    Working...