Ansicht
Dokumentation

CPI4323 - The query access plan has been rebuilt. ( OS/400 )

CPI4323 - The query access plan has been rebuilt. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.
SAP E-Book


Message : CPI4323
The query access plan has been rebuilt.

Message Long Text :

Cause . . . . . : The access plan was rebuilt for reason code &13. The reason codes and their meanings follow:
0 - A new access plan was created.
1 - A file or member is not the same object as the one referred to in the access plan. Some reasons include the object being re-created, restored, or overriden to a new object.
2 - Access plan was using a reusable Open Data Path (ODP), and the optimizer chose to use a non-reusable ODP.
3 - Access plan was using a non-reusable Open Data Path (ODP) and the optimizer chose to use a reusable ODP.
4 - The number of records in member &3 of file &1 in library &2 has changed by more than 10%.
5 - A new access path exists over member &6 of file &4 in library &5.
6 - An access path over member &9 of file &7 in library &8 that was used for this access plan no longer exists or is no longer valid.
7 - The query access plan had to be rebuilt because of system programming changes.
8 - The CCSID (Coded Character Set Identifier) of the current job is different than the CCSID used in the access plan.
9 - The value of one of the following is different in the current job: date format, date separator, time format, or time separator.
10 - The sort sequence table specified has changed.
11 - The number of active processors or the size or paging option of the storage pool has changed.
12 - The system feature DB2 Symmetric Multiprocessing has either been installed or removed.
13 - The value of the degree query attribute has changed either by the CHGSYSVAL or CHGQRYA CL commands or with the query options file &15 in library &16.
14 - A view is either being opened by a high level language open, or is being materialized.
15 - A global variable or sequence object or user-defined type or function is not the same object as the one referred to in the access plan; or, the SQL path used to generate the access plan is different than the current SQL path.
16 - Query attributes have been specified from the query options file &15 in library &16.
17 - The access plan was generated with a commitment control level that is different in the current job.
18 - The access plan was generated with a different static cursor answer set size.
19 - This is the first run of the query since a prepare or compile.
20 and greater -- View the second level message text of the next message issued (CPI4351) for an explanation of these reason codes.
If the reason code is 4, 5, 6, 20, or 21 and the file specified in the reason code explanation is a logical file, then member &12 of physical file &10 in library &11 is the file with the specified change.
Recovery . . . : Excessive rebuilds should be avoided and may indicate an application design problem.
Technical description . . . . . . . . : The access plan was rebuilt because of reason code &13. This reason code has a sub-type identifier of &14 that is used for internal system tracking.

Message File : QCPFMSG
Library Message File : QSYS2924


CPI1466 during Backup   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3267 Date: 20240329 Time: 154725     sap01-206 ( 3 ms )