There are three types of SQL schema in CA-IDMS.
Type R: This is a native SQL schema which is used for collecting native tables, views, functions and any of the procedure types under one logical identifier.
Type A: This is a cloned SQL schema defined to reference a native (type R) SQL schema.
Type N: This is an SQL schema which points to a non-SQL schema and database name combination, which provides for SQL access to that non-SQL defined database.
SQL defined entities can only be placed in a type R schema.
The output of an EXPLAIN statement is a native SQL table and as such it must be directed to a type R schema.
The DB002025 message means you are trying to direct the output of an EXPLAIN statement to a schema of one of the other types, most likely N.