Do you guys know of some reasons that this SBMRMTCMD would just start having issues. This is connect to a remote iSeries. Runs the job and then should return. Below is the Joblog from the Source System.
*NONE Command 07/14/08 21:31:28.380752 QCADRV QSYS 03AE STMDAILY ACTOBJ *STMT
To module . . . . . . . . . : STMDAILY
To procedure . . . . . . . : STMDAILY
Statement . . . . . . . . . : 13400
Message . . . . : 13400 - SBMRMTCMD CMD('CALL (LAWAAA/LAWAPPLY)')
DDMFILE(DBARABS)
CPI9160 Information 00 07/14/08 21:31:28.965480 QCNSDLL QSYS *STMT QTSMGAFT QSYS 0374
From module . . . . . . . . : QCNSINIT
From procedure . . . . . . : RCVEXCSATRD
Statement . . . . . . . . . : 8789
Message . . . . : Database connection started over TCP/IP or a local socket.
Cause . . . . . : The database server job 065818/QUSER/QRWTSRVR has been
allocated on system AAALAWP for handling a new TCP/IP or local socket
connection using DDM protocols. The connection uses IP address 10.0.112.12,
port 446, and user ID DDMUSER at the server. (If the IP address is 0.0.0.0,
it indicates that the connection uses a local socket.) The connection has a
scope of *ACTGRP level in activation group *N with an activation group
number of 2.
CPF9172 Escape 40 07/14/08 21:36:09.588944 QCNSSCPP QSYS *STMT STMDAILY ACTOBJ *STMT
From module . . . . . . . . : QCNSSCPP
From procedure . . . . . . : QCNSSCPP
Statement . . . . . . . . . : 10658
To module . . . . . . . . . : STMDAILY
To procedure . . . . . . . : STMDAILY
Statement . . . . . . . . . : 13400
Message . . . . : SBMRMTCMD command ended abnormally.
Cause . . . . . : A distributed data management (DDM) error was returned by
job 065818/QUSER/QRWTSRVR on the target system AAALAWP which was accessed
5722SS1 V5R4M0 060210 Job Log AAAPROD 07/14/08 21:36:10 Page 4
Job name . . . . . . . . . . : RBSTMDAILY User . . . . . . : QPGMR Number . . . . . . . . . . . : 937226
Job description . . . . . . : RBT2JOBD Library . . . . . : AAAOPER
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
using DDM file DBARABS in library LAWAAA. The error was not a result of the
command submitted by the submit remote command (SBMRMTCMD command). Recovery
. . . : Use the DDM error code returned to determine the error
description. Find any previous System messages relating to the same DDM
file. Examine messages in the target system job or error logs. See the
Distributed Data Management topic in the Information Center book,
http://www.ibm.com/eserver/iseries/infocenter, for more information on DDM
error codes. Technical description . . . . . . . . : DDM data stream error
code is X'1254'.
CPA0702 Sender copy 99 07/14/08 21:36:09.595768 QCLXERR QSYS 00DA QCLXERR QSYS 00DA
Message . . . . : CPF9172 received by procedure STMDAILY. (C D I R)
Cause . . . . . : ILE Control language (CL) procedure STMDAILY in module
STMDAILY in program STMDAILY in library ACTOBJ detected an error at
statement number 0000013400. Message text for CPF9172 is: SBMRMTCMD command
ended abnormally. Use F10 (if available) or the Display Job Log (DSPJOBLOG)
command to see the messages in the job log for a more complete description
of what caused the error. If you still are unable to solve the problem,
please contact your technical support person. Recovery . . . : This
inquiry message can be avoided by changing the procedure. Monitor for the
error (MONMSG command) and perform error recovery within the procedure. To
continue, choose a reply value. Possible choices for replying to message . .
. . . . . . . . . . . . . : C -- Cancel the CL procedure. D -- Dump the CL
procedure variables and cancel the procedure. I -- Ignore the failing
command. R -- Try the failing command again.
*NONE Reply 07/14/08 21:36:09.603784 QMHSNINQ QSYS 0DDA QCLXERR QSYS 00DA
Message . . . . : D
CEE9901 Escape 30 07/14/08 21:36:10.842232 QLEAWI QSYS *STMT RBT637 ROBOTLIB *STMT
From module . . . . . . . . : QLEDEH
From procedure . . . . . . : Q LE leDefaultEh
Statement . . . . . . . . . : 205
To module . . . . . . . . . : RBT637
To procedure . . . . . . . : RBT637
Statement . . . . . . . . . : 51100
Message . . . . : Application error. CPF9172 unmonitored by STMDAILY at
statement 0000013400, instruction X'0000'.
Cause . . . . . : The application ended abnormally because an exception
occurred and was not handled. The name of the program to which the
unhandled exception is sent is STMDAILY STMDAILY STMDAILY. The program was
stopped at the high-level language statement number(s) 0000013400 at the
time the message was sent. If more than one statement number is shown, the
program is an optimized ILE program. Optimization does not allow a single
statement number to be determined. If *N is shown as a value, it means the
real value was not available. Recovery . . . : See the low level messages
previously listed to locate the cause of the exception. Correct any errors,
and then try the request again.
CPI9161 Information 00 07/14/08 21:36:10.852200 QCNSDLL QSYS *STMT QWCCRCRC QSYS 0112
From module . . . . . . . . : QCNSTERM
From procedure . . . . . . : CLSCOMFILE
Statement . . . . . . . . . : 3945
Message . . . . : Database TCP/IP or local socket connection ended.
Cause . . . . . : Use of server job 065818/QUSER/QRWTSRVR has ended on
system AAALAWP for a remote database connection using TCP/IP or a local
5722SS1 V5R4M0 060210 Job Log AAAPROD 07/14/08 21:36:10 Page 5
Job name . . . . . . . . . . : RBSTMDAILY User . . . . . . : QPGMR Number . . . . . . . . . . . : 937226
Job description . . . . . . : RBT2JOBD Library . . . . . : AAAOPER
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
socket connection. The job was handling DDM protocol database requests for
the server using IP address 10.0.112.12, remote port 446, and user ID
DDMUSER. (If the IP address is 0.0.0.0, it indicates that the connection
used a local socket.) The connection had a scope of *ACTGRP level in
activation group *N with an activation group number of 2.
CPI9153 Information 00 07/14/08 21:36:10.852376 QCNSDLL QSYS *STMT QWCCRCRC QSYS 0112
From module . . . . . . . . : QCNSTERM
From procedure . . . . . . : RCLCNVS
Statement . . . . . . . . . : 3634
Message . . . . : 1 DDM conversations ended, 0 remain active.
Cause . . . . . : DDM conversation or conversations with no users were ended
as a result of using the reclaim DDM conversation (RCLDDMCNV command) or
the reclaim resource (RCLRSC command). Recovery . . . : To reclaim
conversations that were not ended, you may need to commit pending changes
and end commitment control, or do a DISCONNECT ALL from interactive SQL, or
a RELEASE ALL followed by COMMIT from interactive SQL.
CPF9898 Escape 40 07/14/08 21:36:10.886720 RBT164 ROBOTLIB *STMT QCMD QSYS 01C7
From module . . . . . . . . : RBT164
From procedure . . . . . . : RBT164
Statement . . . . . . . . . : 87300
Message . . . . : ***Job STMDAILY ended abnormally. 07/14/08 21:36:10.
Cause . . . . . : This message is used by application programs as a general
escape message.
Here is the partial joblog from the Target System
*NONE Command 07/10/08 21:37:30.515336 QCADRV QSYS 03AE LAWAPPLY LAWAAA *STMT
From user . . . . . . . . . : DDMUSER
To module . . . . . . . . . : LAWAPPLY
To procedure . . . . . . . : LAWAPPLY
Statement . . . . . . . . . : 9800
Message . . . . : 9800 - DLTOVR FILE(*PRTF)
CPF9841 Escape 40 07/10/08 21:37:30.515416 QDMDELOV QSYS 01F6 LAWAPPLY LAWAAA *STMT
From user . . . . . . . . . : DDMUSER
To module . . . . . . . . . : LAWAPPLY
To procedure . . . . . . . : LAWAPPLY
Statement . . . . . . . . . : 9800
Message . . . . : Override not found at specified level.
Cause . . . . . : Overrides not found are: *PRTF Recovery . . . : If
the program device names or the file names are not correct, change the
program device name or the file name and try the request again. If the
program device name or the file name is correct, do not use the Delete
Override Device Entry (DLTOVRDEVE) or the Delete Override (DLTOVR) command.
*NONE Command 07/10/08 21:37:30.530288 QCLRTNE QSYS 0058 LAWAPPLY LAWAAA *STMT
From user . . . . . . . . . : DDMUSER
To module . . . . . . . . . : LAWAPPLY
To procedure . . . . . . . : LAWAPPLY
5722SS1 V5R4M0 060210 Display Job Log AAALAWP 07/10/08 21:37:37 Page 938
Job name . . . . . . . . . . : QRWTSRVR User . . . . . . : QUSER Number . . . . . . . . . . . : 058154
Job description . . . . . . : QDFTSVR Library . . . . . : QGPL
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
Statement . . . . . . . . . : 10600
Message . . . . : - RETURN /* RETURN due to end of CL program
*/
CPF9169 Diagnostic 40 07/10/08 21:37:30.552928 QCNTEDDM QSYS *STMT QRWTSRVR QSYS *STMT
From user . . . . . . . . . : DDMUSER
From module . . . . . . . . : QCNTEDDM
From procedure . . . . . . : SNDMSG
Statement . . . . . . . . . : 7919
To module . . . . . . . . . : QRWTSRVR
To procedure . . . . . . . : main
Statement . . . . . . . . . : 250
Message . . . . : Unexpected internal DDM error.
Cause . . . . . : An unexpected error occurred during distributed data
management (DDM) processing. The request being processed at the time may
not have completed. Recovery . . . : Start problem analysis (ANZPRB
command).
CPI9161 Information 00 07/10/08 21:37:36.989816 QCNSDLL QSYS *STMT QCNTDLL QSYS *STMT
From user . . . . . . . . . : DDMUSER
From module . . . . . . . . : QCNSTERM
From procedure . . . . . . : CLSCOMFILE
Statement . . . . . . . . . : 3945
To module . . . . . . . . . : QCNTEXIT
To procedure . . . . . . . : QCNTExit
Statement . . . . . . . . . : 2869
Message . . . . : Database TCP/IP or local socket connection ended.
Cause . . . . . : Use of server job 651225/QUSER/QRWTSRVR has ended on
system AAAPROD for a remote database connection using TCP/IP or a local
socket connection. The job was handling DDM protocol database requests for
the server using IP address 10.0.112.9, remote port 446, and user ID
DDMUSER. (If the IP address is 0.0.0.0, it indicates that the connection
used a local socket.) The connection had a scope of *ACTGRP level in
activation group *N with an activation group number of 37.
CPI9161 Information 00 07/10/08 21:37:36.990112 QCNSDLL QSYS *STMT QCNTDLL QSYS *STMT
From user . . . . . . . . . : DDMUSER
From module . . . . . . . . : QCNSTERM
From procedure . . . . . . : CLSCOMFILE
Statement . . . . . . . . . : 3945
To module . . . . . . . . . : QCNTEXIT
To procedure . . . . . . . : QCNTExit
Statement . . . . . . . . . : 2869
Message . . . . : Database TCP/IP or local socket connection ended.
Cause . . . . . : Use of server job 700663/QUSER/QRWTSRVR has ended on
system AAAPROD for a remote database connection using TCP/IP or a local
socket connection. The job was handling DDM protocol database requests for
the server using IP address 10.0.112.9, remote port 446, and user ID
DDMUSER. (If the IP address is 0.0.0.0, it indicates that the connection
used a local socket.) The connection had a scope of *ACTGRP level in
activation group *N with an activation group number of 2.
CPI9153 Information 00 07/10/08 21:37:36.990304 QCNSDLL QSYS *STMT QCNTDLL QSYS *STMT
From user . . . . . . . . . : DDMUSER
From module . . . . . . . . : QCNSTERM
From procedure . . . . . . : RCLCNVS
5722SS1 V5R4M0 060210 Display Job Log AAALAWP 07/10/08 21:37:37 Page 939
Job name . . . . . . . . . . : QRWTSRVR User . . . . . . : QUSER Number . . . . . . . . . . . : 058154
Job description . . . . . . : QDFTSVR Library . . . . . : QGPL
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
Statement . . . . . . . . . : 3634
To module . . . . . . . . . : QCNTEXIT
To procedure . . . . . . . : QCNTExit
Statement . . . . . . . . . : 2869
Message . . . . : 2 DDM conversations ended, 0 remain active.
Cause . . . . . : DDM conversation or conversations with no users were ended
as a result of using the reclaim DDM conversation (RCLDDMCNV command) or
the reclaim resource (RCLRSC command). Recovery . . . : To reclaim
conversations that were not ended, you may need to commit pending changes
and end commitment control, or do a DISCONNECT ALL from interactive SQL, or
a RELEASE ALL followed by COMMIT from interactive SQL.
Thanks Guys
Bruce "Hoss" Collins
Project Leader/System i Administration
AAA Cooper Transportation
(334) 671-3106
midrange.com
