Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012

    Unanswered: 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=1386

    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.SQLC2H23 0X4141414141424263" was not found.
    $ db2 "get db cfg for dwmm"
    SQL4707N The workload named "SYSDEFAULTUSERWORKLOAD" cannot service the
    request because the workload is not allowed to access the database.

    Any comment will be appreciated.

  2. #2
    Join Date
    Oct 2012
    I tried:
    and restore again, but still doesn't work

  3. #3
    Join Date
    Oct 2012
    I opened a new connection, db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON, restore. It finally works.

  4. #4
    Join Date
    Apr 2006
    Provided Answers: 11
    nullid packages are missing (level change ?)
    you should bind db2ubind.lst and db2cli.lst and/or execute db2updv97
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts