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 -----------------------------------------------------------------------