I am using QCMDEXC to execute a SEQUEL (HelpSystems) View to create a temp file in my RPGLE program. I have a Monitor around the statement: Monitor; cmdstring = %trimr(cmd(2)) + %char(v$hdc) + '''))'; // Sequel View cmdlength = %len(%trim(cmdstring)); $command (cmdstring:cmdlength); On-Error; erz += 1; EndMon; This is the command being executed: EXECUTE VIEW(PRVLPINP2) OUTFILE(LPIWrkLib/F0411L) SETVAR((&KYHDC '25952')) However when the SQL does not find a value it never gets to the On-Error. When tracking in the RDi debugger the execution line disappears, and when I pause execution it is back at the EXFMT line. I pulled the joblog and found that when the SQL fails HTTPAPIR4 executes at statement 4810. I cannot determine why this is occurring. Here is the segment of joblog. 40 03/24/16 12:21:58.901704 QRYRESIG SEQUEL 00B7 P5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : P5504257 To procedure . . . . . . . : P5504257 Statement . . . . . . . . . : 37500 Message . . . . : No records selected by SQL specification. CPF9897 Diagnostic 40 03/24/16 12:22:01.343832 HTTPAPIR4 DEVJDEOBJ *STMT HTTPAPIR4 DEVJDEOBJ *STMT From module . . . . . . . . : HTTPUTILR4 From procedure . . . . . . : UTIL_DIAG Statement . . . . . . . . . : 4810 To module . . . . . . . . . : COMMSSLR4 To procedure . . . . . . . : SSL_ERROR Statement . . . . . . . . . : 7142 Message . . . . : (GSKit) Identifier value is not valid. Cause . . . . . : No additional online help information is available. CPF9897 Diagnostic 40 03/24/16 12:22:01.872264 HTTPAPIR4 DEVJDEOBJ *STMT HTTPAPIR4 DEVJDEOBJ *STMT From module . . . . . . . . : HTTPUTILR4 From procedure . . . . . . : UTIL_DIAG Statement . . . . . . . . . : 4810 To module . . . . . . . . . : COMMSSLR4 To procedure . . . . . . . : SSL_ERROR Statement . . . . . . . . . : 7142 Message . . . . : (GSKit) Identifier value is not valid. Cause . . . . . : No additional online help information is available. CPF9897 Diagnostic 40 03/24/16 12:22:02.136504 HTTPAPIR4 DEVJDEOBJ *STMT HTTPAPIR4 DEVJDEOBJ *STMT From module . . . . . . . . : HTTPUTILR4 From procedure . . . . . . : UTIL_DIAG Statement . . . . . . . . . : 4810 To module . . . . . . . . . : COMMSSLR4 To procedure . . . . . . . : SSL_ERROR 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 20 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST Statement . . . . . . . . . : 7142 Message . . . . : (GSKit) Identifier value is not valid. Cause . . . . . : No additional online help information is available. *NONE Request 03/24/16 12:24:09.540432 QMNSYSRQ QSYS 04A4 QMNSYSRQ QSYS 04A4 Message . . . . : - *SYSTEM/WRKJOB From my pgm code: H Option(*NoDebugIO : *SrcStmt) H DFTACTGRP(*NO) BNDDIR('HTTPAPI') H ACTGRP('HTTPAPI') DATFMT(*ISO) /copy qrpglesrc,httpapi_h The Web Service call works fine, but why is the service program taking over and bullying my flow? That is probably not the right question, but conveys my confusion. Please be so kind as to enlighten me. I attached the complete joblog and program source, just in case. Thanks, Daniel E. `Danny' Hayes Senior JD Edwards Developer 813 901-2150 x133154 cid:image001.png@01CFCC0B.D6D16F30 9119 Corporate Lake Drive | Tampa Florida 33634 | [1]www.carecentrix.com __________________________________________________________________ This communication is intended only for the use of the individual or entity named as the addressee. It may contain information which is privileged and/or confidential under applicable law. If you are not the intended recipient or such recipient's employee or agent, you are hereby notified that any dissemination, copy or disclosure of this communication is strictly prohibited. If you have received this communication in error, please immediately notify CareCentrix Compliance Hot Line at (877) 848-8229 and notify the sender by electronic mail. Please expunge this communication without making any copies. Thank you for your cooperation. References 1. http://www.carecentrix.com/
Attachment:
P5504257.RPGLE
Description: P5504257.RPGLE
5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 2 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 3300 Message . . . . : Object F0411L in LPIWRKLIB type *FILE created. CPC2130 Completion 00 03/24/16 12:19:13.240008 QLICRDUP QSYS 0288 J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 3300 Message . . . . : 1 objects duplicated. Cause . . . . . : All the objects with supported object types specified on the Create Duplicate Object (CRTDUPOBJ) command were duplicated. See low level messages to determine if any objects were not duplicated. CPC2196 Completion 00 03/24/16 12:19:14.911024 QLICUSRL QSYS 0113 J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 3900 Message . . . . : Library LPIWRKLIB added to library list. Cause . . . . . : If the ADDLIBLE command was used, LPIWRKLIB was added to the user library list. If the CHGSYSLIBL command was used, LPIWRKLIB was added to the system portion of the library list. CPI434A Information 00 03/24/16 12:19:18.580872 QQQQUERY QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQQUERY From procedure . . . . . . : QQQQUERY Statement . . . . . . . . . : 14279 Message . . . . : **** Starting optimizer debug message for query . Cause . . . . . : The optimizer debug messages that follow provide query optimization information about how the query was implemented. This message is the first debug message for the query and indicates the start of a set of debug messages. Debug message CPI434B marks the end of the debug messages for this specific query. All the debug messages in between this message and CPI434B describe the overall implementation for this query. CPI432C Information 00 03/24/16 12:19:20.462440 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : All access paths were considered for file F04573. Cause . . . . . : The query optimizer considered all access paths built over member F04573 of file F04573 in library CCXPROD. The list below shows the access paths considered. If file F04573 in library CCXPROD is a logical file then the access paths specified are actually built over member F04573 of physical file F04573 in library CCXPROD. Following each access path name in the list is a reason code which explains why the access path was not used. A reason code of 0 indicates that the access path was used to implement the query. CCXPROD/F04573 6, LMIJDEDTA/F04573L1 6, CCXPROD/F04573LF 6, CCXPROD/F04573LH 6, CCXPROD/F04573LG 4, CCXPROD/F04573LA 11, CCXPROD/F04573LE 6, CCXPROD/F04573LD 6, CCXPROD/F04573LB 6. The reason codes and their meanings follow: 1 - Access path was not in a valid state. The system invalidated the access path. 2 - Access path was not in a valid state. The user requested that the access path be rebuilt. 3 - Access path is a temporary access path (resides in library QTEMP) and was not specified as the file to be queried. 4 - The cost to use this access path, as determined by the optimizer, was higher than the cost associated with the 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 3 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST chosen access method. 5 - The keys of the access path did not match the fields specified for the ordering/grouping criteria. For distributed file queries, the access path keys must exactly match the ordering fields if the access path is to be used when ALWCPYDTA(*YES or *NO) is specified. 6 - The keys of the access path did not match the fields specified for the join criteria. 7 - Use of this access path would not minimize delays when reading records from the file. The user requested to minimize delays when reading records from the file. 8 - The access path cannot be used for a secondary file of the join query because it contains static select/omit selection criteria. The join-type of the query does not allow the use of select/omit access paths for secondary files. 9 - File F04573 contains record ID selection. The join-type of the query forces a temporary access path to be built to process the record ID selection. 10 and greater - View the second level message text of the next message issued (CPI432D) for an explanation of these reason codes. Recovery . . . : The user may want to delete any access paths no longer needed. CPI432D Information 00 03/24/16 12:19:20.466432 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : Additional access path reason codes were used. Cause . . . . . : Message CPI432A or CPI432C was issued immediately before this message. Because of message length restrictions, some of the reason codes used by messages CPI432A and CPI432C are explained below rather than in those messages. The reason codes and their meanings follow: 10 - The user specified ignore decimal data errors on the query. This disallows the use of permanent access paths. 11 - The access path contains static select/omit selection criteria which is not compatible with the selection in the query. 12 - The access path contains static select/omit selection criteria whose compatibility with the selection in the query could not be determined. Either the select/omit criteria or the query selection became too complex during compatibility processing. 13 - The access path contains one or more keys which may be changed by the query during an insert or update. 14 - The access path is being deleted or is being created in an uncommitted unit of work in another process. 15 - The keys of the access path matched the fields specified for the ordering/grouping criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 16 - The keys of the access path matched the fields specified for the join criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 17 - The left-most key of the access path did not match any fields specified for the selection criteria. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 18 - The left-most key of the access path matched a field specified for the selection criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 19 - The access path cannot be used because the secondary file of the join query is a select/omit logical file. The join-type requires that the select/omit access path associated with the secondary file be used or, if dynamic, that an access 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 4 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST path be created by the system. Recovery . . . : See prior message CPI432A or CPI432C for more information. CPI432C Information 00 03/24/16 12:19:20.471856 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : All access paths were considered for file F0411LE. Cause . . . . . : The query optimizer considered all access paths built over member F0411LE of file F0411LE in library CCXPROD. The list below shows the access paths considered. If file F0411LE in library CCXPROD is a logical file then the access paths specified are actually built over member F0411 of physical file F0411 in library CCXPROD. Following each access path name in the list is a reason code which explains why the access path was not used. A reason code of 0 indicates that the access path was used to implement the query. CCXPROD/F0411LE 0, CCXPROD/F0411LA 6, CCXPROD/F0411JA 6, LMIJDEDTA/F0411JDK 6, LMIJDEDTA/F0411LAA 6, LMIJDEDTA/F0411LJW 6, CCXPROD/F74R0491JA 6, CCXPROD/F700411JA 4, CCXPROD/F0411XB 4, CCXPROD/F0411XA 4, CCXPROD/F0411L9 6, CCXPROD/F0411L6 11, CCXPROD/F0411L2 6, CCXPROD/F0411L12 11, CCXPROD/F0411LZ 6, CCXPROD/F0411LY 11, CCXPROD/F0411LX 6, CCXPROD/F0411LV 11, CCXPROD/F0411LU 11, CCXPROD/F0411LT 11, CCXPROD/F0411LS 11, CCXPROD/F0411LR 6, CCXPROD/F0411LQ 11, CCXPROD/F0411LO 11, CCXPROD/F0411LN 11, CCXPROD/F0411LM 11, CCXPROD/F0411LL 6, CCXPROD/F0411LK 6, CCXPROD/F0411LJ 11, CCXPROD/F0411LI 11, CCXPROD/F0411LH 11, CCXPROD/F0411LG 11, CCXPROD/F0411LF 6, CCXPROD/F0411LD 6, CCXPROD/F0411LC 6, CCXPROD/F0411LB 6. The reason codes and their meanings follow: 1 - Access path was not in a valid state. The system invalidated the access path. 2 - Access path was not in a valid state. The user requested that the access path be rebuilt. 3 - Access path is a temporary access path (resides in library QTEMP) and was not specified as the file to be queried. 4 - The cost to use this access path, as determined by the optimizer, was higher than the cost associated with the chosen access method. 5 - The keys of the access path did not match the fields specified for the ordering/grouping criteria. For distributed file queries, the access path keys must exactly match the ordering fields if the access path is to be used when ALWCPYDTA(*YES or *NO) is specified. 6 - The keys of the access path did not match the fields specified for the join criteria. 7 - Use of this access path would not minimize delays when reading records from the file. The user requested to minimize delays when reading records from the file. 8 - The access path cannot be used for a secondary file of the join query because it contains static select/omit selection criteria. The join-type of the query does not allow the use of select/omit access paths for secondary files. 9 - File F0411LE contains record ID selection. The join-type of the query forces a temporary access path to be built to process the record ID selection. 10 and greater - View the second level message text of the next message issued (CPI432D) for an explanation of these reason codes. Recovery . . . : The user may want to delete any access paths no longer needed. CPI432D Information 00 03/24/16 12:19:20.471984 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : Additional access path reason codes were used. 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 5 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST Cause . . . . . : Message CPI432A or CPI432C was issued immediately before this message. Because of message length restrictions, some of the reason codes used by messages CPI432A and CPI432C are explained below rather than in those messages. The reason codes and their meanings follow: 10 - The user specified ignore decimal data errors on the query. This disallows the use of permanent access paths. 11 - The access path contains static select/omit selection criteria which is not compatible with the selection in the query. 12 - The access path contains static select/omit selection criteria whose compatibility with the selection in the query could not be determined. Either the select/omit criteria or the query selection became too complex during compatibility processing. 13 - The access path contains one or more keys which may be changed by the query during an insert or update. 14 - The access path is being deleted or is being created in an uncommitted unit of work in another process. 15 - The keys of the access path matched the fields specified for the ordering/grouping criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 16 - The keys of the access path matched the fields specified for the join criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 17 - The left-most key of the access path did not match any fields specified for the selection criteria. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 18 - The left-most key of the access path matched a field specified for the selection criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 19 - The access path cannot be used because the secondary file of the join query is a select/omit logical file. The join-type requires that the select/omit access path associated with the secondary file be used or, if dynamic, that an access path be created by the system. Recovery . . . : See prior message CPI432A or CPI432C for more information. CPI4327 Information 00 03/24/16 12:19:20.474904 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : File F04573 processed in join position 1. Cause . . . . . : Arrival sequence access was used to select records from member F04573 of file F04573 in library CCXPROD. If file F04573 in library CCXPROD is a logical file then member F04573 of physical file F04573 in library CCXPROD is the actual file in join position 1. A file name that starts with *QUERY for the file indicates it is a temporary file. Recovery . . . : Generally, to force a file to be processed in join position 1, specify an order by field from that file only. Refer to the DB2 UDB for iSeries - Database Performance and Query Optimization topic in the Information Center for additional tips on optimizing a query's join order. CPI4326 Information 00 03/24/16 12:19:20.475304 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : File F0411LE processed in join position 2. 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 6 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST Cause . . . . . : Access path for member F0411LE of file F0411LE in library CCXPROD was used to access records in member F0411LE of file F0411LE in library CCXPROD for reason code 4. The reason codes and their meanings follow: 1 - Perform specified record selection. 2 - Perform specified ordering/grouping criteria. 3 - Record selection and ordering/grouping criteria. 4 - Perform specified join criteria. If file F0411LE in library CCXPROD is a logical file then member F0411 of physical file F0411 in library CCXPROD is the actual file in join position 2. A file name starting with *TEMPX for the access path indicates it is a temporary access path built over file F0411. A file name starting with *N or *QUERY for the file indicates it is a temporary file. Index only access was used for this file within the query: *NO. A value of *YES for index only access processing indicates that all of the fields used from this file for this query can be found within the access path of file F0411LE. A value of *NO indicates that index only access could not be performed for this access path. Index only access is generally a performance advantage since all of the data can be extracted from the access path and the data space does not have to be paged into active memory. Recovery . . . : Generally, to force a file to be processed in join position 1, specify an order by field from that file only. If ordering is desired, specifying ORDER BY fields over more than one file forces the creation of a temporary file and allows the optimizer to optimize the join order of all the files. No file is forced to be first. An access path can only be considered for index only access if all of the fields used within the query for this file are also key fields for that access path. Refer to the DB2 UDB for iSeries - Database Performance and Query Optimization topic in the Information Center for additional tips on optimizing a query's join order and index only access. CPI432F Information 00 03/24/16 12:19:20.475752 QQQIMPLE QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 Message . . . . : Access path suggestion for file F0411LE. Cause . . . . . : To improve performance the query optimizer is suggesting a permanent access path be built with the key fields it is recommending. The access path will access records from member F0411LE of file F0411LE in library CCXPROD. In the list of key fields that follow, the query optimizer is recommending the first 0 key fields as primary key fields. The remaining key fields are considered secondary key fields and are listed in order of expected selectivity based on this query. Primary key fields are fields that significantly reduce the number of keys selected based on the corresponding selection predicate. Secondary key fields are fields that may or may not significantly reduce the number of keys selected. It is up to the user to determine the true selectivity of secondary key fields and to determine whether those key fields should be used when creating the access path. The query optimizer is able to perform key positioning over any combination of the primary key fields, plus one additional secondary key field. Therefore it is important that the first secondary key field be the most selective secondary key field. The query optimizer will use key selection with any remaining secondary key fields. While key selection is not as fast as key positioning it can still reduce the number of keys selected. Hence, secondary key fields that are fairly selective should be included. When building the access path all primary key fields should be specified first 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 7 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST followed by the secondary key fields which are prioritized by selectivity. The following list contains the suggested primary and secondary key fields: RPURAT. If file F0411LE in library CCXPROD is a logical file then the access path should be built over member F0411 of physical file F0411 in library CCXPROD. Recovery . . . : If this query is run frequently, you may want to create the suggested access path for performance reasons. It is possible that the query optimizer will choose not to use the access path just created. For more information, refer to the DB2 UDB for iSeries - Database Performance and Query Optimization topic in the Information Center or the DB2 UDB for iSeries SQL Reference topic in the Information Center information in the iSeries Information Center. CPI434B Information 00 03/24/16 12:19:20.502888 QQQQUERY QSYS *STMT QRYO03 SEQUEL 007F From module . . . . . . . . : QQQQUERY From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 27954 Message . . . . : **** Ending debug message for query . Cause . . . . . : This message marks the end of the debug messages for this specific query. All the debug messages in between this message and CPI434A describe the overall implementation for the query. QRY7004 Completion 00 03/24/16 12:19:22.114712 QRYO03 SEQUEL 0182 J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 4002 Message . . . . : 361 records processed, 361 records inserted. CPC7303 Completion 00 03/24/16 12:21:24.424184 QDBCHGFI QSYS *STMT P5504257 DEVJDEOBJ *STMT From module . . . . . . . . : QDBCHGFI From procedure . . . . . . : QDBCHGFI Statement . . . . . . . . . : 18528 To module . . . . . . . . . : P5504257 To procedure . . . . . . . : P5504257 Statement . . . . . . . . . : 36300 Message . . . . : File F0411L in library LPIWRKLIB changed. JVAB56D Diagnostic 00 03/24/16 12:21:39.161168 QJVAJVMXIF QSYS *STMT QJVAJVMXIF QSYS *STMT From module . . . . . . . . : QJVAJVMXIF From procedure . . . . . . : sendMessage__10QjvaJvmXifFPcN21 Statement . . . . . . . . . : 10 To module . . . . . . . . . : QJVAJVMXIF To procedure . . . . . . . : check_J9_Envvar__10QjvaJvmXifFv Statement . . . . . . . . . : 143 Message . . . . : Java Virtual Machine is Classic. JVAB529 Diagnostic 40 03/24/16 12:21:39.282920 QJVAUTLJVM QSYS *STMT SQLQRYMJNI SEQUEL *STMT From module . . . . . . . . : QJVAUTLJVM From procedure . . . . . . : JvaSendMsg Statement . . . . . . . . . : 4 To module . . . . . . . . . : SQLQRYMJNI To procedure . . . . . . . : startJVM__Fv Statement . . . . . . . . . : 9 Message . . . . : Public write authority on "/rio/rio.jar". Cause . . . . . : Directory "/rio/rio.jar" in the classpath has public write authority. If more than one class file in a directory has the same name, the first one found is run. Recovery . . . : If the Classpath security check level (CHKPATH) is *SECURE, the command cannot complete if a directory in 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 8 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST the classpath has public write authority. Have your administrator remove public write authority from directory "/rio/rio.jar", or change CHKPATH and run the command again. If directory "/rio/rio.jar" remains public write authority and CHKPATH is not *SECURE, you may verify which classes are run by setting the OPTION parameter to *VERBOSE and running the command again. JVAB529 Diagnostic 40 03/24/16 12:21:39.287304 QJVAUTLJVM QSYS *STMT SQLQRYMJNI SEQUEL *STMT From module . . . . . . . . : QJVAUTLJVM From procedure . . . . . . : JvaSendMsg Statement . . . . . . . . . : 4 To module . . . . . . . . . : SQLQRYMJNI To procedure . . . . . . . : startJVM__Fv Statement . . . . . . . . . : 9 Message . . . . : Public write authority on "/sequel/sequelj.jar". Cause . . . . . : Directory "/sequel/sequelj.jar" in the classpath has public write authority. If more than one class file in a directory has the same name, the first one found is run. Recovery . . . : If the Classpath security check level (CHKPATH) is *SECURE, the command cannot complete if a directory in the classpath has public write authority. Have your administrator remove public write authority from directory "/sequel/sequelj.jar", or change CHKPATH and run the command again. If directory "/sequel/sequelj.jar" remains public write authority and CHKPATH is not *SECURE, you may verify which classes are run by setting the OPTION parameter to *VERBOSE and running the command again. JVAB529 Diagnostic 40 03/24/16 12:21:39.339696 QJVAUTLJVM QSYS *STMT SQLQRYMJNI SEQUEL *STMT From module . . . . . . . . : QJVAUTLJVM From procedure . . . . . . : JvaSendMsg Statement . . . . . . . . . : 4 To module . . . . . . . . . : SQLQRYMJNI To procedure . . . . . . . : startJVM__Fv Statement . . . . . . . . . : 9 Message . . . . : Public write authority on "/rio/lib". Cause . . . . . : Directory "/rio/lib" in the classpath has public write authority. If more than one class file in a directory has the same name, the first one found is run. Recovery . . . : If the Classpath security check level (CHKPATH) is *SECURE, the command cannot complete if a directory in the classpath has public write authority. Have your administrator remove public write authority from directory "/rio/lib", or change CHKPATH and run the command again. If directory "/rio/lib" remains public write authority and CHKPATH is not *SECURE, you may verify which classes are run by setting the OPTION parameter to *VERBOSE and running the command again. QRY2233 Information 00 03/24/16 12:21:52.078968 CVTSQL SEQUEL *STMT SQLQRYM SEQUEL *STMT From module . . . . . . . . : CVTSQL From procedure . . . . . . : CVTSQL Statement . . . . . . . . . : 156 To module . . . . . . . . . : SQLQRYM To procedure . . . . . . . : RUNQRY__FP10viewspec_tP9wdmufcb_tP7qdbqh_tPc5F ixedXSP18_c Statement . . . . . . . . . : 74 Message . . . . : SQL statement translated from *SEQUEL syntax to standard SQL The SQL statement was translated to: SELECT f1.* FROM ccxprod/f04573 f0,ccxprod/f0411 f1 WHERE f0.kikco=f1.rpkco AND f0.kidoc=f1.rpdoc AND 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 9 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST f0.kidct=f1.rpdct AND f0.kisfx=f1.rpsfx AND f0.kian8=f1.rpan8 AND KIHDC=25952 AND RPURAT<>0 AND RPPST='#' AND RPVINV LIKE '%LPI%' CPI4323 Information 00 03/24/16 12:21:52.605832 QQQQUERY QSYS *STMT QSQRUN1 QSYS *STMT From module . . . . . . . . : QQQQUERY From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4274 To module . . . . . . . . . : QSQPREP To procedure . . . . . . . : PPBLDQAP Statement . . . . . . . . . : 28398 Message . . . . : The query access plan has been rebuilt. Cause . . . . . : The access plan was rebuilt for reason code 0. The reason codes and their meanings follow: 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 *N of file *N in library *N has changed by more than 10%. 5 - A new access path exists over member *N of file *N in library *N. 6 - An access path over member *N of file *N in library *N 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 UDB 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 *N in library *N. 14 - A view is either being opened by a high level language open, or is being materialized. 15 - A 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 *N in library *N. 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 *N of physical file *N in library *N 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 0. This reason code has a sub-type identifier of X'0000' that is used for internal system tracking. SQL7968 Completion 00 03/24/16 12:21:52.669264 QSQRUN1 QSYS *STMT QSQRUN1 QSYS *STMT From module . . . . . . . . : QSQDESC From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 20842 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 10 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST To module . . . . . . . . . : QSQDESC To procedure . . . . . . . : CLEANUP Statement . . . . . . . . . : 20842 Message . . . . : DESCRIBE of prepared statement SQLSTATEMENT000003 completed. SQL7967 Completion 00 03/24/16 12:21:52.669480 QSQRUN1 QSYS *STMT QSQRUN1 QSYS *STMT From module . . . . . . . . : QSQPREP From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 11184 To module . . . . . . . . . : QSQPREP To procedure . . . . . . . : CLEANUP Statement . . . . . . . . . : 11184 Message . . . . : PREPARE of statement SQLSTATEMENT000003 completed. CPI434A Information 00 03/24/16 12:21:52.680176 QQQQUERY QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQQUERY From procedure . . . . . . : QQQQUERY Statement . . . . . . . . . : 14279 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : **** Starting optimizer debug message for query . Cause . . . . . : The optimizer debug messages that follow provide query optimization information about how the query was implemented. This message is the first debug message for the query and indicates the start of a set of debug messages. Debug message CPI434B marks the end of the debug messages for this specific query. All the debug messages in between this message and CPI434B describe the overall implementation for this query. CPI4323 Information 00 03/24/16 12:21:58.378376 QQQQUERY QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQQUERY From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4274 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : The query access plan has been rebuilt. Cause . . . . . : The access plan was rebuilt for reason code 0. The reason codes and their meanings follow: 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 *N of file *N in library *N has changed by more than 10%. 5 - A new access path exists over member *N of file *N in library *N. 6 - An access path over member *N of file *N in library *N 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 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 11 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST has changed. 12 - The system feature DB2 UDB 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 *N in library *N. 14 - A view is either being opened by a high level language open, or is being materialized. 15 - A 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 *N in library *N. 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 *N of physical file *N in library *N 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 0. This reason code has a sub-type identifier of X'0000' that is used for internal system tracking. CPI433D Information 00 03/24/16 12:21:58.414328 QQQQUERY QSYS *STMT QQQQUERY QSYS *STMT From module . . . . . . . . : QQQQUERY From procedure . . . . . . : BUILDAP Statement . . . . . . . . . : 27899 To module . . . . . . . . . : QQQQUERY To procedure . . . . . . . : QQQQUERY Statement . . . . . . . . . : 15645 Message . . . . : Query options used to build the query access plan. Cause . . . . . : The access plan that was saved was created with query options retrieved from file QAQQINI in library QUSRSYS. CPI432C Information 00 03/24/16 12:21:58.466488 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : All access paths were considered for file F04573. Cause . . . . . : The query optimizer considered all access paths built over member F04573 of file F04573 in library CCXPROD. The list below shows the access paths considered. If file F04573 in library CCXPROD is a logical file then the access paths specified are actually built over member F04573 of physical file F04573 in library CCXPROD. Following each access path name in the list is a reason code which explains why the access path was not used. A reason code of 0 indicates that the access path was used to implement the query. CCXPROD/F04573 0, LMIJDEDTA/F04573L1 4, CCXPROD/F04573LF 4, CCXPROD/F04573LH 4, CCXPROD/F04573LG 4, CCXPROD/F04573LA 11, CCXPROD/F04573LE 4, CCXPROD/F04573LD 4, CCXPROD/F04573LB 4. The reason codes and their meanings follow: 1 - Access path was not in a valid state. The system invalidated the access path. 2 - Access path was not in a valid state. The user requested that the access path be rebuilt. 3 - Access path 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 12 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST is a temporary access path (resides in library QTEMP) and was not specified as the file to be queried. 4 - The cost to use this access path, as determined by the optimizer, was higher than the cost associated with the chosen access method. 5 - The keys of the access path did not match the fields specified for the ordering/grouping criteria. For distributed file queries, the access path keys must exactly match the ordering fields if the access path is to be used when ALWCPYDTA(*YES or *NO) is specified. 6 - The keys of the access path did not match the fields specified for the join criteria. 7 - Use of this access path would not minimize delays when reading records from the file. The user requested to minimize delays when reading records from the file. 8 - The access path cannot be used for a secondary file of the join query because it contains static select/omit selection criteria. The join-type of the query does not allow the use of select/omit access paths for secondary files. 9 - File F04573 contains record ID selection. The join-type of the query forces a temporary access path to be built to process the record ID selection. 10 and greater - View the second level message text of the next message issued (CPI432D) for an explanation of these reason codes. Recovery . . . : The user may want to delete any access paths no longer needed. CPI432D Information 00 03/24/16 12:21:58.466624 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : Additional access path reason codes were used. Cause . . . . . : Message CPI432A or CPI432C was issued immediately before this message. Because of message length restrictions, some of the reason codes used by messages CPI432A and CPI432C are explained below rather than in those messages. The reason codes and their meanings follow: 10 - The user specified ignore decimal data errors on the query. This disallows the use of permanent access paths. 11 - The access path contains static select/omit selection criteria which is not compatible with the selection in the query. 12 - The access path contains static select/omit selection criteria whose compatibility with the selection in the query could not be determined. Either the select/omit criteria or the query selection became too complex during compatibility processing. 13 - The access path contains one or more keys which may be changed by the query during an insert or update. 14 - The access path is being deleted or is being created in an uncommitted unit of work in another process. 15 - The keys of the access path matched the fields specified for the ordering/grouping criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 16 - The keys of the access path matched the fields specified for the join criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 17 - The left-most key of the access path did not match any fields specified for the selection criteria. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 18 - The left-most key of the access path matched a field specified for the selection criteria. However, the sequence table associated with the access path did not match the 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 13 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST sequence table associated with the query. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 19 - The access path cannot be used because the secondary file of the join query is a select/omit logical file. The join-type requires that the select/omit access path associated with the secondary file be used or, if dynamic, that an access path be created by the system. Recovery . . . : See prior message CPI432A or CPI432C for more information. CPI432C Information 00 03/24/16 12:21:58.471616 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : All access paths were considered for file F0411. Cause . . . . . : The query optimizer considered all access paths built over member F0411 of file F0411 in library CCXPROD. The list below shows the access paths considered. If file F0411 in library CCXPROD is a logical file then the access paths specified are actually built over member F0411 of physical file F0411 in library CCXPROD. Following each access path name in the list is a reason code which explains why the access path was not used. A reason code of 0 indicates that the access path was used to implement the query. CCXPROD/F0411LE 0, CCXPROD/F0411LA 4, CCXPROD/F0411JA 6, LMIJDEDTA/F0411JDK 4, LMIJDEDTA/F0411LAA 6, LMIJDEDTA/F0411LJW 6, CCXPROD/F74R0491JA 4, CCXPROD/F700411JA 4, CCXPROD/F0411XB 4, CCXPROD/F0411XA 4, CCXPROD/F0411L9 4, CCXPROD/F0411L6 11, CCXPROD/F0411L2 4, CCXPROD/F0411L12 11, CCXPROD/F0411LZ 4, CCXPROD/F0411LY 11, CCXPROD/F0411LX 6, CCXPROD/F0411LV 11, CCXPROD/F0411LU 11, CCXPROD/F0411LT 11, CCXPROD/F0411LS 11, CCXPROD/F0411LR 6, CCXPROD/F0411LQ 11, CCXPROD/F0411LO 11, CCXPROD/F0411LN 11, CCXPROD/F0411LM 11, CCXPROD/F0411LL 4, CCXPROD/F0411LK 6, CCXPROD/F0411LJ 11, CCXPROD/F0411LI 11, CCXPROD/F0411LH 11, CCXPROD/F0411LG 11, CCXPROD/F0411LF 6, CCXPROD/F0411LD 4, CCXPROD/F0411LC 4, CCXPROD/F0411LB 4. The reason codes and their meanings follow: 1 - Access path was not in a valid state. The system invalidated the access path. 2 - Access path was not in a valid state. The user requested that the access path be rebuilt. 3 - Access path is a temporary access path (resides in library QTEMP) and was not specified as the file to be queried. 4 - The cost to use this access path, as determined by the optimizer, was higher than the cost associated with the chosen access method. 5 - The keys of the access path did not match the fields specified for the ordering/grouping criteria. For distributed file queries, the access path keys must exactly match the ordering fields if the access path is to be used when ALWCPYDTA(*YES or *NO) is specified. 6 - The keys of the access path did not match the fields specified for the join criteria. 7 - Use of this access path would not minimize delays when reading records from the file. The user requested to minimize delays when reading records from the file. 8 - The access path cannot be used for a secondary file of the join query because it contains static select/omit selection criteria. The join-type of the query does not allow the use of select/omit access paths for secondary files. 9 - File F0411 contains record ID selection. The join-type of the query forces a temporary access path to be built to process 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 14 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST the record ID selection. 10 and greater - View the second level message text of the next message issued (CPI432D) for an explanation of these reason codes. Recovery . . . : The user may want to delete any access paths no longer needed. CPI432D Information 00 03/24/16 12:21:58.471744 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : Additional access path reason codes were used. Cause . . . . . : Message CPI432A or CPI432C was issued immediately before this message. Because of message length restrictions, some of the reason codes used by messages CPI432A and CPI432C are explained below rather than in those messages. The reason codes and their meanings follow: 10 - The user specified ignore decimal data errors on the query. This disallows the use of permanent access paths. 11 - The access path contains static select/omit selection criteria which is not compatible with the selection in the query. 12 - The access path contains static select/omit selection criteria whose compatibility with the selection in the query could not be determined. Either the select/omit criteria or the query selection became too complex during compatibility processing. 13 - The access path contains one or more keys which may be changed by the query during an insert or update. 14 - The access path is being deleted or is being created in an uncommitted unit of work in another process. 15 - The keys of the access path matched the fields specified for the ordering/grouping criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 16 - The keys of the access path matched the fields specified for the join criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. 17 - The left-most key of the access path did not match any fields specified for the selection criteria. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 18 - The left-most key of the access path matched a field specified for the selection criteria. However, the sequence table associated with the access path did not match the sequence table associated with the query. Therefore, key row positioning could not be performed, making the cost to use this access path higher than the cost associated with the chosen access method. 19 - The access path cannot be used because the secondary file of the join query is a select/omit logical file. The join-type requires that the select/omit access path associated with the secondary file be used or, if dynamic, that an access path be created by the system. Recovery . . . : See prior message CPI432A or CPI432C for more information. CPI4326 Information 00 03/24/16 12:21:58.472096 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 15 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST Message . . . . : File F04573 processed in join position 1. Cause . . . . . : Access path for member F04573 of file F04573 in library CCXPROD was used to access records in member F04573 of file F04573 in library CCXPROD for reason code 1. The reason codes and their meanings follow: 1 - Perform specified record selection. 2 - Perform specified ordering/grouping criteria. 3 - Record selection and ordering/grouping criteria. 4 - Perform specified join criteria. If file F04573 in library CCXPROD is a logical file then member F04573 of physical file F04573 in library CCXPROD is the actual file in join position 1. A file name starting with *TEMPX for the access path indicates it is a temporary access path built over file F04573. A file name starting with *N or *QUERY for the file indicates it is a temporary file. Index only access was used for this file within the query: *NO. A value of *YES for index only access processing indicates that all of the fields used from this file for this query can be found within the access path of file F04573. A value of *NO indicates that index only access could not be performed for this access path. Index only access is generally a performance advantage since all of the data can be extracted from the access path and the data space does not have to be paged into active memory. Recovery . . . : Generally, to force a file to be processed in join position 1, specify an order by field from that file only. If ordering is desired, specifying ORDER BY fields over more than one file forces the creation of a temporary file and allows the optimizer to optimize the join order of all the files. No file is forced to be first. An access path can only be considered for index only access if all of the fields used within the query for this file are also key fields for that access path. Refer to the DB2 UDB for iSeries - Database Performance and Query Optimization topic in the Information Center for additional tips on optimizing a query's join order and index only access. CPI4326 Information 00 03/24/16 12:21:58.472456 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : File F0411 processed in join position 2. Cause . . . . . : Access path for member F0411LE of file F0411LE in library CCXPROD was used to access records in member F0411 of file F0411 in library CCXPROD for reason code 4. The reason codes and their meanings follow: 1 - Perform specified record selection. 2 - Perform specified ordering/grouping criteria. 3 - Record selection and ordering/grouping criteria. 4 - Perform specified join criteria. If file F0411 in library CCXPROD is a logical file then member F0411 of physical file F0411 in library CCXPROD is the actual file in join position 2. A file name starting with *TEMPX for the access path indicates it is a temporary access path built over file F0411. A file name starting with *N or *QUERY for the file indicates it is a temporary file. Index only access was used for this file within the query: *NO. A value of *YES for index only access processing indicates that all of the fields used from this file for this query can be found within the access path of file F0411LE. A value of *NO indicates that index only access could not be performed for this access path. Index only access is generally a performance advantage since all of the data can be extracted from the access 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 16 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST path and the data space does not have to be paged into active memory. Recovery . . . : Generally, to force a file to be processed in join position 1, specify an order by field from that file only. If ordering is desired, specifying ORDER BY fields over more than one file forces the creation of a temporary file and allows the optimizer to optimize the join order of all the files. No file is forced to be first. An access path can only be considered for index only access if all of the fields used within the query for this file are also key fields for that access path. Refer to the DB2 UDB for iSeries - Database Performance and Query Optimization topic in the Information Center for additional tips on optimizing a query's join order and index only access. CPI432F Information 00 03/24/16 12:21:58.473112 QQQIMPLE QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQIMPLE From procedure . . . . . . : QQQSNDPMSG Statement . . . . . . . . . : 4737 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : Access path suggestion for file F0411. Cause . . . . . : To improve performance the query optimizer is suggesting a permanent access path be built with the key fields it is recommending. The access path will access records from member F0411 of file F0411 in library CCXPROD. In the list of key fields that follow, the query optimizer is recommending the first 2 key fields as primary key fields. The remaining key fields are considered secondary key fields and are listed in order of expected selectivity based on this query. Primary key fields are fields that significantly reduce the number of keys selected based on the corresponding selection predicate. Secondary key fields are fields that may or may not significantly reduce the number of keys selected. It is up to the user to determine the true selectivity of secondary key fields and to determine whether those key fields should be used when creating the access path. The query optimizer is able to perform key positioning over any combination of the primary key fields, plus one additional secondary key field. Therefore it is important that the first secondary key field be the most selective secondary key field. The query optimizer will use key selection with any remaining secondary key fields. While key selection is not as fast as key positioning it can still reduce the number of keys selected. Hence, secondary key fields that are fairly selective should be included. When building the access path all primary key fields should be specified first followed by the secondary key fields which are prioritized by selectivity. The following list contains the suggested primary and secondary key fields: RPPST, RPVINV, RPURAT. If file F0411 in library CCXPROD is a logical file then the access path should be built over member F0411 of physical file F0411 in library CCXPROD. Recovery . . . : If this query is run frequently, you may want to create the suggested access path for performance reasons. It is possible that the query optimizer will choose not to use the access path just created. For more information, refer to the DB2 UDB for iSeries - Database Performance and Query Optimization topic in the Information Center or the DB2 UDB for iSeries SQL Reference topic in the Information Center information in the iSeries Information Center. CPI434B Information 00 03/24/16 12:21:58.476992 QQQQUERY QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QQQQUERY 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 17 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 27954 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : FULL_OPEN Statement . . . . . . . . . : 23520 Message . . . . : **** Ending debug message for query . Cause . . . . . : This message marks the end of the debug messages for this specific query. All the debug messages in between this message and CPI434A describe the overall implementation for the query. SQL7912 Information 00 03/24/16 12:21:58.483600 QSQRUN3 QSYS *STMT QSQROUTX QSYS *STMT From module . . . . . . . . : QSQOPEN From procedure . . . . . . : SNDINFOMSG Statement . . . . . . . . . : 24845 To module . . . . . . . . . : QSQROUTX To procedure . . . . . . . : XTPROCES Statement . . . . . . . . . : 16172 Message . . . . : ODP created. Cause . . . . . : An Open Data Path (ODP) has been created. No reusable ODP could be found. This occurs in the following cases: -- This is the first time the statement has been run. -- A RCLRSC has been issued since the last run of this statement. -- The last run of the statement caused the ODP to be deleted. -- If this is an OPEN statement, the last CLOSE of this cursor caused the ODP to be deleted. -- The Application Server (AS) has been changed by a CONNECT statement. Recovery . . . : If a cursor is being opened many times in an application, it is more efficient to use a reusable ODP, and not create an ODP every time. This also applies to repeated runs of INSERT, UPDATE, DELETE, and SELECT INTO statements. If ODPs are being created on every open, see the close message to determine why the ODP is being deleted. SQL7916 Information 00 03/24/16 12:21:58.483784 QSQRUN3 QSYS *STMT QSQROUTX QSYS *STMT From module . . . . . . . . : QSQOPEN From procedure . . . . . . : SNDINFOMSG Statement . . . . . . . . . : 24845 To module . . . . . . . . . : QSQROUTX To procedure . . . . . . . : XTPROCES Statement . . . . . . . . . : 16172 Message . . . . : Blocking used for query. Cause . . . . . : Blocking has been used in the implementation of this query. SQL will retrieve a block of records from the database manager on the first FETCH statement. Additional FETCH statements have to be issued by the calling program, but they do not require SQL to request more records, and therefore will run faster. Recovery . . . : SQL attempts to utilize blocking whenever possible. In cases where the cursor is not update capable, and commitment control is not active, there is a possibility that blocking will be used. SQL7962 Completion 00 03/24/16 12:21:58.483984 QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT From module . . . . . . . . : QSQOPEN From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 22148 To module . . . . . . . . . : QSQOPEN To procedure . . . . . . . : CLEANUP Statement . . . . . . . . . : 22148 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 18 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST Message . . . . : Cursor SQLCURSOR000000003 opened. Cause . . . . . : The cursor was opened with result set identifier of 0. If the result set identifier is non-zero, the result table for this cursor is eligible to be accessed as a stored procedure result set. SQL0100 Information 00 03/24/16 12:21:58.805976 QSQRUN2 QSYS *STMT QSQRUN2 QSYS *STMT From module . . . . . . . . : QSQFETCH From procedure . . . . . . : CK_DEBUG Statement . . . . . . . . . : 15591 To module . . . . . . . . . : QSQFETCH To procedure . . . . . . . : CK_DEBUG Statement . . . . . . . . . : 15591 Message . . . . : Row not found for SQLCURSOR000000003. Cause . . . . . : One of the following conditions has occurred: -- If this is a FETCH statement, no more rows satisfy the selection values (end of file). The name of the cursor is SQLCURSOR000000003 and the result set identifier is 0. If the result set identifier is non-zero, the result table for this cursor was being accessed as a stored procedure result set. -- If this is a FETCH statement for a scrollable cursor, a record was not found. If NEXT was specified, end of file was reached. If PRIOR was specified, the beginning of the file was reached. If RELATIVE was specified, either the beginning of file or the end of file was reached, depending on the value specified. If FIRST or LAST was specified, then no records satisfy the selection criteria. The name of the cursor is SQLCURSOR000000003. -- If this is an embedded SELECT statement, no rows satisfy the selection values. -- If this is an UPDATE, INSERT, or DELETE statement, no rows satisfy the subselect or WHERE clause. No rows were updated, inserted, or deleted. Recovery . . . : No recovery is necessary. SQL7913 Information 00 03/24/16 12:21:58.818368 QSQSBAS QSYS *STMT QSQSBAS QSYS *STMT From module . . . . . . . . : QSQHDCLS From procedure . . . . . . : SQHRDCLS Statement . . . . . . . . . : 3433 To module . . . . . . . . . : QSQCLSCR To procedure . . . . . . . : SQCLOSE Statement . . . . . . . . . : 5123 Message . . . . : ODP deleted. Cause . . . . . : The Open Data Path (ODP) for this statement or cursor has been deleted. The ODP was not reusable. This could be caused by ordering on a host variable or because the query optimizer chose to accomplish the query with an ODP that was not reusable. Recovery . . . : See previous query optimizer messages to determine how the cursor was opened. SQL7959 Completion 00 03/24/16 12:21:58.818752 QSQRUN4 QSYS *STMT QSQRUN4 QSYS *STMT From module . . . . . . . . : QSQCLS From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 4795 To module . . . . . . . . . : QSQCLS To procedure . . . . . . . : CLEANUP Statement . . . . . . . . . : 4795 Message . . . . : Cursor SQLCURSOR000000003 was closed. Cause . . . . . : Cursor SQLCURSOR000000003 with result set identifier of 0 was closed. If the result set identifier is non-zero, the result table of the cursor was being accessed as a stored procedure result set. CPI3E04 Information 00 03/24/16 12:21:58.848080 QRWSARDB QSYS *STMT QSQCONN QSYS *STMT 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 19 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST From module . . . . . . . . : QRWSARDB From procedure . . . . . . : DISCMSG Statement . . . . . . . . . : 11857 To module . . . . . . . . . : QSQCONN To procedure . . . . . . . : RW_DISCONNECT Statement . . . . . . . . . : 16942 Message . . . . : Connection to relational database S10E05A4 ended. Cause . . . . . : Connection to relational database S10E05A4 has ended. The connection uses remote location name *LOCAL, device name *N, mode name *N, local location name *N, remote network identifier *N, user ID DDHAYES, and transaction program name *N. This connection is for activation group *DFTACTGRP with an activation group number of 2. SQL7984 Completion 00 03/24/16 12:21:58.849904 QSQCONN QSYS *STMT QSQCONN QSYS *STMT From module . . . . . . . . : QSQCONN From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 20204 To module . . . . . . . . . : QSQCONN To procedure . . . . . . . : CLEANUP Statement . . . . . . . . . : 20204 Message . . . . : DISCONNECT completed. Cause . . . . . : DISCONNECT to relational database S10E05A4 completed. If the relational database is *N, then the *LOCAL entry has not been added to the relational database directory. QRY6004 Completion 40 03/24/16 12:21:58.901704 QRYRESIG SEQUEL 00B7 P5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : P5504257 To procedure . . . . . . . : P5504257 Statement . . . . . . . . . : 37500 Message . . . . : No records selected by SQL specification. CPF9897 Diagnostic 40 03/24/16 12:22:01.343832 HTTPAPIR4 DEVJDEOBJ *STMT HTTPAPIR4 DEVJDEOBJ *STMT From module . . . . . . . . : HTTPUTILR4 From procedure . . . . . . : UTIL_DIAG Statement . . . . . . . . . : 4810 To module . . . . . . . . . : COMMSSLR4 To procedure . . . . . . . : SSL_ERROR Statement . . . . . . . . . : 7142 Message . . . . : (GSKit) Identifier value is not valid. Cause . . . . . : No additional online help information is available. CPF9897 Diagnostic 40 03/24/16 12:22:01.872264 HTTPAPIR4 DEVJDEOBJ *STMT HTTPAPIR4 DEVJDEOBJ *STMT From module . . . . . . . . : HTTPUTILR4 From procedure . . . . . . : UTIL_DIAG Statement . . . . . . . . . : 4810 To module . . . . . . . . . : COMMSSLR4 To procedure . . . . . . . : SSL_ERROR Statement . . . . . . . . . : 7142 Message . . . . : (GSKit) Identifier value is not valid. Cause . . . . . : No additional online help information is available. CPF9897 Diagnostic 40 03/24/16 12:22:02.136504 HTTPAPIR4 DEVJDEOBJ *STMT HTTPAPIR4 DEVJDEOBJ *STMT From module . . . . . . . . : HTTPUTILR4 From procedure . . . . . . : UTIL_DIAG Statement . . . . . . . . . : 4810 To module . . . . . . . . . : COMMSSLR4 To procedure . . . . . . . : SSL_ERROR 5722SS1 V5R4M0 060210 Display Job Log OHS7 03/24/16 12:42:45 Page 20 Job name . . . . . . . . . . : DEVA3 User . . . . . . : DDHAYES Number . . . . . . . . . . . : 205290 Job description . . . . . . : DDHAYES Library . . . . . : QGPL MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST Statement . . . . . . . . . : 7142 Message . . . . : (GSKit) Identifier value is not valid. Cause . . . . . : No additional online help information is available. *NONE Request 03/24/16 12:24:09.540432 QMNSYSRQ QSYS 04A4 QMNSYSRQ QSYS 04A4 Message . . . . : - *SYSTEM/WRKJOB CPF9812 Escape 40 03/24/16 12:42:15.538480 QWHRMBRD QSYS 0426 J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 4600 Message . . . . : File F55060 in library LPIWRKLIB not found. Cause . . . . . : The file name or the library name is not correct. If the library name was not specified, the file may be in a library that is not contained in the library list. Recovery . . . : Correct the file or library name, or add the library name to the library list. Then try the request again. CPF2105 Escape 40 03/24/16 12:42:15.538976 QLIDLOBJ QSYS 051B J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 8500 Message . . . . : Object F55060 in LPIWRKLIB type *FILE not found. Cause . . . . . : No object was found for the name or type specified. Recovery . . . : Specify the correct name or type of the object. Then try the request again. CPC2191 Completion 00 03/24/16 12:42:15.588832 QLIDLOBJ QSYS 051B J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 8600 Message . . . . : Object F0411L in LPIWRKLIB type *FILE deleted. CPC3101 Completion 00 03/24/16 12:42:15.604648 QDBCLRPF QSYS 0238 J5504257 DEVJDEOBJ *STMT To module . . . . . . . . . : J5504257 To procedure . . . . . . . : J5504257 Statement . . . . . . . . . : 8602 Message . . . . : Member LPIWRKF file LPIWRKF in LPIWRKLIB cleared.
----------------------------------------------------------------------- This is the FTPAPI mailing list. To unsubscribe, please go to: http://www.scottklement.com/mailman/listinfo/ftpapi -----------------------------------------------------------------------