IBM i (iSeries) Power 7 - WinSQL

Question

I am having an sudden issue, I have a IBM Power 7 iseries AS/400 server, I just store my database here, the development team works with Genexus and from yesterday we are unable to create tables (for example) in the server not even running the commands directly in the iseries box, we have rebooted the box twice, we have looked for logs and nothing, the winsql software we use only reports a Error:

SQL0901 - Error del sistema SQL. (State:S1000, Native Code: FFFFFC7B)

Can anyone help me out with this? or how to follow up on this, we have been using this IBM power 7 iseries for 3 years....

Answer 1

SQL0901 is a generic message. The QZDASOINIT joblog will have more details.

See ODBC diagnostic and performance tools for more information.

Answer 2

Some possibly helpful information regarding the msg SQL0901
My SWAG for the scenario is that there is an error with the System Database Cross Reference (DBXREF) giving rise to the error, and the preceding error(s) [logged in the joblog of the job servicing the SQL CREATE request] will diagnose that condition; the table likely can be created using a short name [for the TABLE and the CONSTRAINT], or the TABLE with CONSTRAINT may be able to be created into a different library. If such a condition is the origin, then some diagnostic information could be collected [e.g. dumps of objects tracking the *DBXREF feature and history logs] followed by the recovery action of reclaiming [a portion of] the DBXREF data [for the specific library exhibiting the error].