Datstage solutions, knowledge base, FAQ and best practices

2.20. How to check Datastage internal error descriptions

To check the description of a number go to the datastage shell (from administrator or telnet to the server machine) and invoke the following command:

SELECT * FROM SYS.MESSAGE WHERE @ID='081021'; - where in that case the number 081021 is an error number

The command will produce a brief error description which probably will not be helpful in resolving an issue but can be a good starting point for further analysis.