What is -818 SQLCODE & how to resolve it?

-818 SQLCODE

Time-stamp mismatch between PLAN and load module.
Solution - Rebind the given component.

-911 SQLCODE

-911 SQLCODE

Deadlock.
Given task will go in deadlock, when resource is not available for long time.

-904 SQLCODE

-904 SQLCODE

Resource not available.
db2 SQL query will throw this error while db2 resource is not available.
Solution - Delay the given query and retry for the operation.

-803 SQLCODE

-803 SQLCODE

Duplicate record while INSERT.
db2 SQL query will throw this error while inserting duplicate record into db2 table.

How to resolve -805 SQLCODE in db2?

How to resolve -805 SQLCODE in db2?

This sqlcode code indicates than DBRM not found. DBRM/package not found in given Plan
Solution - Bind the corresponding component.

S878 abend in JCL.

S878 abend in JCL.

Cause - This abend occurs due to not enough virtual private storage space available.
Solution - Increas the region space in job card.