Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004

    Red face Unanswered: "snap_get_tbsp" which cannot be accessed


    I get the following error when trying to view tablespaces in control center.
    after installing Alternate fixpack and upgrading from UDB 8.1 FP6 (AIX) to
    UDB 8.1 FP13.

    [IBM][CLI Driver][DB2/6000] SQL0444N Routine "*GET_TBSP"
    (specific name "SNAP_GET_TBSP") is implemented with code in
    library or path "...ib/bin/routine/db2dbroutext", function
    "snap_get_tbsp" which cannot be accessed. Reason code: "5".

    Is there anyone who can assist please. My searches thus far has been to no avail.


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Have you properly upgraded your instance and run the "db2updv8" tool as the FixPak readme tells you to do?

    I could imagine that you did not properly applied all steps for the FP upgrade and, therefore, an old version of the library "db2dbroutext" exists in your sqllib/function/ directory, which is now causing problems.

    p.s: Any reason why you are not moving to the latest FP (FP14) right away?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2006
    Pune , India
    ..just a guess
    have u done db2updv8 after applying FP
    and bind necessary bind files on each DB
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Jun 2004

    Red face Re: Viewing tablespace info

    Just to set the record straight.

    I've done the db2updv8, I've binded all my utilities, client, schema etc.

    The db2routext was definitely updated since the timestamp on the file was that of the upgrade date.
    The server has been rebooted.
    I rebinded all pakages again just incase.
    I have one more question though, the tools tables that was created on the old version would that apply to the new version or are there additional tools tables that need to be created.

    Thanks for response thus far, appreciate it.

Posting Permissions

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