Running an Explain got the following bad SQLCODE.
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70008, TYPE OF RESOURCE
00000220, AND RESOURCE NAME BX998D.DSNDBC.DSNDB04.DSNR14CD.I0-
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOD2 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -205 13172746 0 13820889 -1041948669
12714048 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF33' X'00C9000A' X'00000000'
X'00D2E3D9' X'C1E52003' X'00C20040' SQL DIAGNOSTIC
DSNT417I SQLWARN0-5 = , , , , , SQL WARNINGS
DSNT417I SQLWARN6-A = , , , , SQL WARNINGS
The meaning of the message was that DSNR14CD table space could not be created but there was not any more messages in the output to figure out the cause. Plan Analyzer automatically creates the DB2 objects that are needed for the Explain if they have not been created previously.