Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    19

    Exclamation Unanswered: Cannot use db after FP 13 install!!!

    Sun Solaris, UDB v8.1, fp 10.

    I've done the following:
    ./installFixPak13 -y -> successful
    ./db2iupdt -e -> successful
    db2start -> successful

    then got following:
    1st server>>
    t01epp1t:/ # db2 connect to t01epprt
    SQL1013N The database alias name or database name "" could not be found.
    SQLSTATE=42705

    2nd server>>
    db2 force application all
    SQL1001N "" is not a valid database name. SQLSTATE=2E000

    All of my databases are now down. Does ANYONE know what causes this situation and how to fix it?

    thanks,
    jholman

  2. #2
    Join Date
    Nov 2006
    Posts
    19
    Install said successful, but not all packages installed. I am reinstalling now.

  3. #3
    Join Date
    Dec 2006
    Posts
    1
    Hi brdholman,

    did you solve your problem regarding to this issue,
    <-
    t01epp1t:/ # db2 connect to t01epprt
    SQL1013N The database alias name or database name "" could not be found.
    SQLSTATE=42705
    ->

    I have exactly the same issue with FP 13,
    thank you in advance
    Regards,
    Suparmann

  4. #4
    Join Date
    Nov 2006
    Posts
    19
    Yes I did. I should have posted that back. Sorry.

    Two things were wrong according to IBM. The first one may or may not have had something to do with it.
    1. Make sure to kill ALL db2 processes before updating the instance.
    2. When I applied FixPak 10, right after the initial install, I used 'db2iupdt -d'. I was told to use 'db2iupdt -u <fencename> <instname>' or 'db2iupdt -u <instname> <instname>'. Then log into a new session as the instance, do a db2level to confirm, then db2start from there.

    After that it was fine.
    Do be sure to rebind the db2 utilities in this directory:
    $HOME/sqllib/bnd/bind
    "db2 bind @db2ubind.lst blocking all grant public action REPLACE"
    Do not use 'action add' or it doesn't work properly as I found out.

    Hope this helps,
    jholman

Posting Permissions

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