SQLSTATE values
Errors and warnings are returned from the Db2® Mirror procedures and functions using SQLSTATE values. SQLSTATE values that start with '01' are warnings.
Common SQLSTATEs are:
- 01520
- Character string conversion error.
- 01532
- Object not found.
- 01548
- Not authorized to perform specified operation.
- 01623
- Db2 Symmetric Multiprocessing feature not installed.
- 01687
- Lock not obtained.
- 01692
- Warning returned from command.
- 01H53
- Procedure or function returned a warning.
- 08001
- Communication failure.
- 02000
- Row not found.
- 23505
- Duplicate rule in Replication Criteria List.
- 42501
- Not authorized to object.
- 42502
- Not authorized to perform specified operation.
- 42602
- Name not valid.
- 42616
- Parameter value not valid.
- 42704
- Object not found.
- 42710
- Object already exists.
42718
- The local server name is not defined.
- 54035
- Internal object limit exceeded.
- 55019
- Operation not allowed due to different version levels.
- 560CR
- Db2 Mirror not installed.
- 560DE
- The Db2 Mirror operation is not allowed in the current state.
- 57011
- Storage not available.
- 57033
- Lock not obtained.
- 58004
- Unexpected system error.