Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    120

    Unanswered: database system error

    Hi all,
    I'm using DB2 10.1 ESE on Linux 64 bit.

    I got the following error:

    [IBM][CLI Driver][DB2/LINUXX8664] SQL0901N The SQL statement
    or command failed because of a database system error. (Reason
    "sqlrl_userTempOpen: usertemp entry not found".) SQLSTATE=58004

    The documentation I looked at says it can depend on the DB2 upgrade but no upgrade has been performed since DB2 10.1 was installed.

    Any idea which could be the cause?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    new installation or upgrade from v9
    if upgrade try db2updv10 -d xxx
    there is a similar apar
    IC64206 for 9.1 and should be in V10
    it is always possible that this is a new bug..
    Last edited by przytula_guy; 02-07-13 at 09:59.
    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

Posting Permissions

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