Hello,
my customer is migrating from DB2 zOS v 12.0 to Db2 Linux v 11.5.9 in AWS EC2 environment. IBM COBOL online/batch applications running in mainframe have been converted to Microfocus Cobol and are running from a separate AWS EC2 server. Customer is asking to me how to identify SQL0904N errors.
I don't remember to have seen SQL0904N errors in Db2 LUW, except for cases in where I accessed Db2 for z/OS from Db2 LUW via DRDA. I reviewed the IBM Documentation for SQL0904N error message and found that is a DB2 zOS error related. Explained to customer that in Db2 LUW there is no direct equivalent, SQL0904N is the closest generic LUW error when a required resource is unavailable, but many z/OS -904 conditions are mapped in LUW to more specific SQL codes such as SQL0911N, SQL0290N, SQL0954C, or SQL0668N depending on the resource involved. I'm right ?
Customer mentioned that he has previously seen -904 errors in Micro Focus COBOL applications but has not yet provided to me a sample showing the error.
Has anyone already encountered this issue ?
Thanks. Ciao. Roberto.