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

    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.
    SQLSTATE=51002
    $ 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.
    SQLSTATE=5U020


    Any comment will be appreciated.

  2. #2
    Join Date
    Oct 2012
    Posts
    3
    I tried:
    db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON
    and restore again, but still doesn't work

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

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

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
  •