 Re: sql0902c reason code 122
"Stefano Tesini" <TESOTESO@teso.elitel.biz> wrote in message
news:c856i3$kl9$1@news.flashnet.it...[color=blue]
> Hi all,
>
> when i drop a table, i take his error :
> [IBM][CLI Driver][DB2/NT] SQL0902C System error (REASON CODE = "122").
>
> Why ?
>
> Ver UDB Server nt 7.1.0
> Ver UDB Cli 7.1.0 Win 98 or XP the error is the same.
>
> 1000 Thank.
>[/color]
The Message Reference says:
---
SQL0902C A system error (reason code = "<reason-code>") occurred.
Subsequent SQL statements cannot be processed.
Explanation: A system error occurred.
User Response: Record the message number (SQLCODE) and reason code in the
message.
If trace was active, invoke the Independent Trace Facility at the operating
system command prompt. Refer to the Independent Trace Facility in the
Troubleshooting Guide for information on how to use this facility. Then
contact your technical service representative with the following
information:
a.. Problem description
b.. SQLCODE and embedded reason code
c.. SQLCA contents if possible
d.. Trace file if possible.
Federated system users: isolate the problem to the data source failing the
request (refer to the Troubleshooting Guide to determine which data source
is failing to process the SQL statement) and take the necessary diagnostic
steps for that data source. The problem determination procedures for data
sources vary, so refer to the applicable data source manuals.
sqlcode: -902
sqlstate: 58005
---
It looks like you'll have to call IBM Support to figure out what the Reason
Code 122 means; it appears that IBM chose not to publish the meaning of that
reason code.
Before you do that, try running the Independent Trace Facility as they
suggest to see if it tells you anything that *you* can use. Also, check the
db2diag.log in \sqllib\DB2 and see if it has anything useful. You could also
try a Google search on "SQL0902C" to see if anyone else has reported a
similar problem. If none of that helps, you should probably call IBM
Support.
Rhino
| 
