We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

CPD436A - Index creation required, but index creation disallowed. ( OS/400 )

CPD436A - Index creation required, but index creation disallowed. ( OS/400 )

General Data in Customer Master   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.
SAP E-Book


Message : CPD436A
Index creation required, but index creation disallowed.

Message Long Text :

Cause . . . . . : In order for this query to run, an index would need to be created to access records from member &6 of &18 &19 in library &5 for reason code &10. The reason codes and their meanings follow:
1 - Perform specified ordering/grouping criteria.
2 - Perform specified join criteria.
3 - Perform specified record selection to minimize I/O wait time.
A file name starting with *QUERY or *N indicates a temporary file was needed and an index needs to be created over the temporary file, thus the user cannot create the required index. Users cannot create the required index over table functions.
The index would need the following key fields:
&17.
A key field of *MAP indicates the key field is an expression (derived field), thus the user cannot create the required index.
The access path needs to be created using sequence table &13 in library &14.
A sequence table of *N indicates the access path must be created without a sequence table. A sequence table of *I indicates that the table is an internally derived table that is not available to the user, thus the user cannot create the required index.
If &18 &19 in library &5 is a logical file then an index would need to be created over member &9 of physical file &7 in library &8.
Recovery . . . : Do one of the following and try your request again:
-- Create the index using the keys and sequence table provided.
-- Remove the disallow index creation option.
-- Change the query to not require an index or temporary file.
-- If the reason code above is 3 and the query completion option is to minimize I/O wait time, change the option to minimize the time for the entire query, since the former option will usually cause an index to be created.

Message File : QCPFMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3265 Date: 20201031 Time: 181221     sap01-206 ( 2 ms )