Could it be that someone has played with the OVRxxxx (PRTF?) or DLTOVR
command defaults on the remote system?
Kevin Wright.
-----Original Message-----
From: Bruce Collins [mailto:Bruce.Collins@xxxxxxxxxxxxx]
Sent: Wednesday, 16 July 2008 8:15 AM
To: Midrange Systems Technical Discussion
Subject: SBMRMTCMD Error
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
