Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    58

    Lightbulb SQL2310N The utility could not generate statistics.

    Got the error below when running runstat on cronjob.

    SQL2310N The utility could not generate statistics. Error "-900" was returned.

    Any idea what error -900 means?

    Thanks in advance.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,649
    -900 is sqlcode

    SQL0900N The application state is in error. A database
    connection does not exist.

    Explanation: A connection to a database does not exist. This
    may be due to one of the following reasons:

    o A serious error in the application state has caused the
    database connection to be lost.

    o The application may have disconnected from a database and not
    established a new current connection before executing the
    next SQL statement.



    User Response: Reestablish a current connection be either
    switching to an existing dormant connection (using CONNECT TO or
    SET CONNECTION) or by establishing a new connection (using
    CONNECT).

    sqlcode: -900

    sqlstate: 08003
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2004
    Posts
    58
    Thanks for the information.

    I am new to DB2. Just wonder why an application error would cause failure in generating statistics in the database? Does RUNSTATS involve not only the database but application as well? I checked the dialog.log but did see any errors reported on that day. Where else can I look for errors reported in the database? Thanks.

Posting Permissions

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