Difference between revisions of "ARS0013E"
(Added troubleshooting of CMOD arsmaint errors.) |
|||
| Line 8: | Line 8: | ||
Message Text: DB Error: text -- SQLSTATE=state, SQLCODE=code, File=file, Line=line | Message Text: DB Error: text -- SQLSTATE=state, SQLCODE=code, File=file, Line=line | ||
== | == Examples == | ||
arssockd (ARCHIVE): 05/09/15 02:43:30 73629 ARSLOAD 2 13 DB Error: [IBM][CLI Driver] CLI0122E Program type out of range. SQLSTATE=HY003 -- SQLSTATE=HY003, SQLCODE=-99999, File=arsdoc.c, Line=4217 | arssockd (ARCHIVE): 05/09/15 02:43:30 73629 ARSLOAD 2 13 DB Error: [IBM][CLI Driver] CLI0122E Program type out of range. SQLSTATE=HY003 -- SQLSTATE=HY003, SQLCODE=-99999, File=arsdoc.c, Line=4217 | ||
ARSMAINT 434684 Error No 13 DB Error: RUNSTATS ON TABLE root.SL25 -- SQLSTATE=Not Defined, SQLCODE=1, File=arssys.c, Line=1287 | |||
== What were you doing? == | == What were you doing? == | ||
Probably trying to start CMOD, after a new installation, upgrade, or database change. This can also happen when loading data into CMOD and the data presented to the database isn't what is expected. In the example above, a Generic Index File that contained a NULL value was being loaded. | Probably trying to start CMOD, after a new installation, upgrade, or database change. This can also happen when loading data into CMOD and the data presented to the database isn't what is expected. In the example above, a Generic Index File that contained a NULL value was being loaded. | ||
This error message can occur during database maintenance with the IBM CMOD arsmaint command, if there was an error that occurred during database maintenance. | This error message can also occur during database maintenance with the IBM CMOD arsmaint command with the -r option, if there was an error that occurred during database maintenance. | ||
== What happened? == | == What happened? == | ||
| Line 22: | Line 24: | ||
This is a generic database error message -- CMOD passes along what little information it receives from the database engine on the error. | This is a generic database error message -- CMOD passes along what little information it receives from the database engine on the error. | ||
If you encountered this error during database maintenance with CMOD's arsmaint command, try running the maintenance command again when the server is less busy, or have your database administrator run the table reorganizations or statistics collection while CMOD is offline. | |||
To find more information on what's causing the error, check your database engine diagnostic logs. | To find more information on what's causing the error, check your database engine diagnostic logs. | ||
Revision as of 17:12, 10 February 2017
What was the error?
Message Number: 13
Message Name: ARS0013E (Corrective action is required to continue)
Message Text: DB Error: text -- SQLSTATE=state, SQLCODE=code, File=file, Line=line
Examples
arssockd (ARCHIVE): 05/09/15 02:43:30 73629 ARSLOAD 2 13 DB Error: [IBM][CLI Driver] CLI0122E Program type out of range. SQLSTATE=HY003 -- SQLSTATE=HY003, SQLCODE=-99999, File=arsdoc.c, Line=4217 ARSMAINT 434684 Error No 13 DB Error: RUNSTATS ON TABLE root.SL25 -- SQLSTATE=Not Defined, SQLCODE=1, File=arssys.c, Line=1287
What were you doing?
Probably trying to start CMOD, after a new installation, upgrade, or database change. This can also happen when loading data into CMOD and the data presented to the database isn't what is expected. In the example above, a Generic Index File that contained a NULL value was being loaded.
This error message can also occur during database maintenance with the IBM CMOD arsmaint command with the -r option, if there was an error that occurred during database maintenance.
What happened?
Whatever you were working on failed, because CMOD received a message from the database that it wasn't expecting. This is a "pass-through" error that CMOD records in the System Log to assist with troubleshooting & debugging. In many situations, even if the message from the database wasn't critical, CMOD interprets any unexpected message as an error, and stops processing.
Troubleshooting
This is a generic database error message -- CMOD passes along what little information it receives from the database engine on the error.
If you encountered this error during database maintenance with CMOD's arsmaint command, try running the maintenance command again when the server is less busy, or have your database administrator run the table reorganizations or statistics collection while CMOD is offline.
To find more information on what's causing the error, check your database engine diagnostic logs.
In DB2, the database server diagnostic logs can be found in the sqllib/db2dump directory, primarily in the db2diag.log file.
Refer to your local Database Administrator for assistance in resolving issues with your preferred database engine.
DB2 10.5 Messages Reference
DB2 10.1 Messages Reference
DB2 9.8 Messages Reference
DB2 9.7 Messages Reference
DB2 9.5 Messages Reference