1,126
edits
Difference between revisions of "ARS0013E"
Jump to navigation
Jump to search
Added troubleshooting of CMOD arsmaint errors.
(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. | ||