Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18

    Unanswered: regarding db2 udb v8.1.0 installation

    hello friends,

    I am using OS: RedHat Enterprise Linux v4.0 and DB2: IDM DB2 UDB V8.1


    friends, i just deinstall the db2 and trying to install but unable to install.... when the name of the instance is suppose to give there it showing db2inst2 but it suppose to show db2inst and the error message is as follows:

    ""ERROR: Could not switch current DB2INSTANCE to "db2inst1". The return code is "-2029059916" ""

    can any one post your view plz...

    Thanks & Regards

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Here is what "db2diag -rc" says to this error message:

    Input ZRC string '-2029059916' parsed as 0x870F00B4 (-2029059916).

    ZRC value to map: 0x870F00B4 (-2029059916)

    ZRC class :
    Global Processing Error (Class Index: 7)
    Component:
    SQLO ; oper system services (Component Index: 15)
    Reason Code:
    180 (0x00B4)

    Identifer:
    SQLO_NO_INSTANCE
    Identifer (without component):
    SQLZ_OSS_INTERNAL_ERROR_26

    Description:
    No instance available.

    Associated information:
    Sqlcode -902
    SQL0902C A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed.

    Number of sqlca tokens : 1
    Diaglog message number: 1
    Since I didn't understand what exactly you tried and where you got the error, I can't figure out what's going on.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18
    hello,

    i uninstalled the previous db2 and tryed to install the db2 udb with linux. In installation of product... when i tryed to create a new instance it showing that db2inst2 insted of db2inst1 as per the ibm for c shell the default instance must be db2inst1 .... when i forcely given the db2inst1 name in the setup.log file it given that error message and in db2iupdt.log.5220 file if given regarding that error as follows:

    The error may occur because of the following reasons:
    1. This user id does not exist on the system.
    2. The home directory of this user is not set up properly.
    3. One of the user attributes needed by db2 is unset.
    4. The UID of this user is 0.

    i tried mannualy also but the same error message is comming...

    can u plz now....

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What is the output of "db2ilist"? What is the output of "grep db2inst /etc/passwd"? What is the output of "ls -l /home" (assuming that's where your home directories are)?
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The "db2inst1" is a suggestion only. You can always change that to whichever user you like. For example, I use "stolze" as default instance on my laptop.

    What about the 4 things from the db2iupdt.log? Have you checked those? If so, what were the results?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18
    hello friends,

    thanks for all of you..... its working with db2inst1 instance .... problem is with variable present in the profile file.... i removed that and re-installed its working now....

    thanks again for all...

Posting Permissions

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