help with stored procedure abend

Brad Wissink

help with stored procedure abend

I am working on a stored procedure that is failing and I'm not getting any information on why.  The batch application program get the following error message and put out the other messages. 

READY                                                                     
 DSN SYSTEM(DB2P)                                                         
DSN                                                                       
 RUN  PROGRAM(TPDB2TST) PLAN(PPSAP008)       LIB('BJW.PROD1.LOADLIB')     
DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE X'00D30109'  
DSN                                                                       
 END                                                                      
READY                                                                     
END                                                                       

WS-SQLCODE AFTER CONNECT = 000000000    
WS-SQLCODEP AFTER CONNECT = 000000000   
PSQLSTATE  =                            
PSQLERRMC  =                            
                                        
                                        
WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS   
WS-SQLCODE AFTER CALL = 000000430       
WS-SQLSTATE AFTER CALL = 000038503      
PSQLCODE   = 000000000                  
AGENT NAME =                            
ADDR LINE1 =                            
ADDR LINE2 =                            
ADDR CITY  =                            
ADDR STATE =                            
ADDR ZIP =                              
TPDB2IFC CALL RETURN-CODE = 0000        

the 430 sqlcode says the stored procedure abnormally terminated.

So from the stored procedure side I get this from DSNTRACE

DSNA800I  DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80   
DSNA805I  DSNACA00 TCB=00AFC628 CONNECT REQUEST    SSID=DB8T  TECBP=18113590  SECBP=18113598  RIBW=181135A0           
DSNA826I  DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 18113598                         
DSNA827I  DSNACA00 TCB=00AFC628 AFTER  VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000                     
DSNA826I  DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 18113590                        
DSNA827I  DSNACA00 TCB=00AFC628 AFTER  VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000                    
DSNA825I  DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111 CABDECPP=00000000 EIBPARM=00000000                            
DSNA813I  DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000                
DSNA814I  DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=80                  
DSNA810I  DSNACA70 TCB=00AFC628 BEFORE IDENTIFY ==============================                                        

 

And this from the MVS SYSLOG

DSNX906I  ! DSNX9CAC PROCEDURE OR FUNCTION 890                       
PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION   
HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT                  

and that is it.   how do I find out what caused the abnormal termination?

 

 

Chris Hoelscher

help with stored procedure abend
(in response to Brad Wissink)
00D30109

Explanation
Phase 1 of a distributed commit failed. One or more remote servers did one of
the following actions:
o Voted NO
o Voted heuristic mixed
o Experienced a communications error
o Made an error in their use of commit protocol

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Brad Wissink [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:53 PM
To: [login to unmask email]
Subject: [DB2-L] - help with stored procedure abend


I am working on a stored procedure that is failing and I'm not getting any information on why. The batch application program get the following error message and put out the other messages.

READY
DSN SYSTEM(DB2P)
DSN
RUN PROGRAM(TPDB2TST) PLAN(PPSAP008) LIB('BJW.PROD1.LOADLIB')
DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE X'00D30109'
DSN
END
READY
END

WS-SQLCODE AFTER CONNECT = 000000000
WS-SQLCODEP AFTER CONNECT = 000000000
PSQLSTATE =
PSQLERRMC =


WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS
WS-SQLCODE AFTER CALL = 000000430
WS-SQLSTATE AFTER CALL = 000038503
PSQLCODE = 000000000
AGENT NAME =
ADDR LINE1 =
ADDR LINE2 =
ADDR CITY =
ADDR STATE =
ADDR ZIP =
TPDB2IFC CALL RETURN-CODE = 0000

the 430 sqlcode says the stored procedure abnormally terminated.

So from the stored procedure side I get this from DSNTRACE

DSNA800I DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80
DSNA805I DSNACA00 TCB=00AFC628 CONNECT REQUEST SSID=DB8T TECBP=18113590 SECBP=18113598 RIBW=181135A0
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 18113598
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 18113590
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000
DSNA825I DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111 CABDECPP=00000000 EIBPARM=00000000
DSNA813I DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=80
DSNA810I DSNACA70 TCB=00AFC628 BEFORE IDENTIFY ==============================



And this from the MVS SYSLOG

DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 890
PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION
HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT

and that is it. how do I find out what caused the abnormal termination?





-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
Attachments

  • image001.jpg (<1k)

Brad Wissink

help with stored procedure abend
(in response to Chris Hoelscher)
I saw this earlier and except for the communication error I don’t know what any of that means. So where do I find an explanation of what it means that the remote server ‘voted NO’ or ‘voted heuristic mixed’? What causes an ‘error in their use of commit protocol’?

From: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:00 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: help with stored procedure abend

00D30109

Explanation
Phase 1 of a distributed commit failed. One or more remote servers did one of
the following actions:
o Voted NO
o Voted heuristic mixed
o Experienced a communications error
o Made an error in their use of commit protocol

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Brad Wissink [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:53 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - help with stored procedure abend


I am working on a stored procedure that is failing and I'm not getting any information on why. The batch application program get the following error message and put out the other messages.

READY
DSN SYSTEM(DB2P)
DSN
RUN PROGRAM(TPDB2TST) PLAN(PPSAP008) LIB('BJW.PROD1.LOADLIB')
DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE X'00D30109'
DSN
END
READY
END

WS-SQLCODE AFTER CONNECT = 000000000
WS-SQLCODEP AFTER CONNECT = 000000000
PSQLSTATE =
PSQLERRMC =


WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS
WS-SQLCODE AFTER CALL = 000000430
WS-SQLSTATE AFTER CALL = 000038503
PSQLCODE = 000000000
AGENT NAME =
ADDR LINE1 =
ADDR LINE2 =
ADDR CITY =
ADDR STATE =
ADDR ZIP =
TPDB2IFC CALL RETURN-CODE = 0000

the 430 sqlcode says the stored procedure abnormally terminated.

So from the stored procedure side I get this from DSNTRACE

DSNA800I DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80
DSNA805I DSNACA00 TCB=00AFC628 CONNECT REQUEST SSID=DB8T TECBP=18113590 SECBP=18113598 RIBW=181135A0
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 18113598
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 18113590
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000
DSNA825I DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111 CABDECPP=00000000 EIBPARM=00000000
DSNA813I DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=80
DSNA810I DSNACA70 TCB=00AFC628 BEFORE IDENTIFY ==============================



And this from the MVS SYSLOG

DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 890
PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION
HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT

and that is it. how do I find out what caused the abnormal termination?





-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----

The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
Attachments

  • image001.jpg (<1k)

Lizette Koehler

help with stored procedure abend
(in response to Brad Wissink)
I would think you would need to get logs from the remote server to answer that. DB2 is only reporting on what the remote told it.



Lizette





From: Wissink, Brad [mailto:[login to unmask email]
Sent: Thursday, January 11, 2018 8:53 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: help with stored procedure abend



I saw this earlier and except for the communication error I don’t know what any of that means. So where do I find an explanation of what it means that the remote server ‘voted NO’ or ‘voted heuristic mixed’? What causes an ‘error in their use of commit protocol’?



From: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:00 PM
To: '[login to unmask email]' <[login to unmask email] <mailto:[login to unmask email]> >
Subject: [DB2-L] - RE: help with stored procedure abend



00D30109



Explanation

Phase 1 of a distributed commit failed. One or more remote servers did one of

the following actions:

o Voted NO

o Voted heuristic mixed

o Experienced a communications error

o Made an error in their use of commit protocol



Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services



123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266



From: Brad Wissink [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:53 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - help with stored procedure abend



I am working on a stored procedure that is failing and I'm not getting any information on why. The batch application program get the following error message and put out the other messages.

READY
DSN SYSTEM(DB2P)
DSN
RUN PROGRAM(TPDB2TST) PLAN(PPSAP008) LIB('BJW.PROD1.LOADLIB')
DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE X'00D30109'
DSN
END
READY
END

WS-SQLCODE AFTER CONNECT = 000000000
WS-SQLCODEP AFTER CONNECT = 000000000
PSQLSTATE =
PSQLERRMC =


WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS
WS-SQLCODE AFTER CALL = 000000430
WS-SQLSTATE AFTER CALL = 000038503
PSQLCODE = 000000000
AGENT NAME =
ADDR LINE1 =
ADDR LINE2 =
ADDR CITY =
ADDR STATE =
ADDR ZIP =
TPDB2IFC CALL RETURN-CODE = 0000

the 430 sqlcode says the stored procedure abnormally terminated.

So from the stored procedure side I get this from DSNTRACE

DSNA800I DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80
DSNA805I DSNACA00 TCB=00AFC628 CONNECT REQUEST SSID=DB8T TECBP=18113590 SECBP=18113598 RIBW=181135A0
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 18113598
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 18113590
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000
DSNA825I DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111 CABDECPP=00000000 EIBPARM=00000000
DSNA813I DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=80
DSNA810I DSNACA70 TCB=00AFC628 BEFORE IDENTIFY ==============================



And this from the MVS SYSLOG

DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 890
PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION
HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT

and that is it. how do I find out what caused the abnormal termination?







-----End Original Message-----


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

-----End Original Message-----


The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

-----End Original Message-----

Brad Wissink

help with stored procedure abend
(in response to Lizette Koehler)
The remote server is another MVS lpar and I am only getting the following from the MSTR address space.

DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 230
PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION
HAS BEEN STOPPED. ASID= 0117 WLM_ENV= DB2WLM_DEFLTT

DSN3201I ! ABNORMAL EOT IN PROGRESS FOR USER=DB8TUSR 231
CONNECTION-ID=RRSAF CORRELATION-ID= JOBNAME=DB8TWLM
ASID=0117 TCB=00AD1AA0

Is there somewhere else I can look for more information?

From: Lizette Koehler [mailto:[login to unmask email]
Sent: Thursday, January 11, 2018 10:20 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: help with stored procedure abend

I would think you would need to get logs from the remote server to answer that. DB2 is only reporting on what the remote told it.

Lizette


From: Wissink, Brad [mailto:[login to unmask email]
Sent: Thursday, January 11, 2018 8:53 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: help with stored procedure abend

I saw this earlier and except for the communication error I don’t know what any of that means. So where do I find an explanation of what it means that the remote server ‘voted NO’ or ‘voted heuristic mixed’? What causes an ‘error in their use of commit protocol’?

From: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:00 PM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - RE: help with stored procedure abend

00D30109

Explanation
Phase 1 of a distributed commit failed. One or more remote servers did one of
the following actions:
o Voted NO
o Voted heuristic mixed
o Experienced a communications error
o Made an error in their use of commit protocol

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Brad Wissink [mailto:[login to unmask email]
Sent: Wednesday, January 10, 2018 5:53 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - help with stored procedure abend


I am working on a stored procedure that is failing and I'm not getting any information on why. The batch application program get the following error message and put out the other messages.

READY
DSN SYSTEM(DB2P)
DSN
RUN PROGRAM(TPDB2TST) PLAN(PPSAP008) LIB('BJW.PROD1.LOADLIB')
DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE X'00D30109'
DSN
END
READY
END

WS-SQLCODE AFTER CONNECT = 000000000
WS-SQLCODEP AFTER CONNECT = 000000000
PSQLSTATE =
PSQLERRMC =


WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS
WS-SQLCODE AFTER CALL = 000000430
WS-SQLSTATE AFTER CALL = 000038503
PSQLCODE = 000000000
AGENT NAME =
ADDR LINE1 =
ADDR LINE2 =
ADDR CITY =
ADDR STATE =
ADDR ZIP =
TPDB2IFC CALL RETURN-CODE = 0000

the 430 sqlcode says the stored procedure abnormally terminated.

So from the stored procedure side I get this from DSNTRACE

DSNA800I DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80
DSNA805I DSNACA00 TCB=00AFC628 CONNECT REQUEST SSID=DB8T TECBP=18113590 SECBP=18113598 RIBW=181135A0
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 18113598
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000
DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 18113590
DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000
DSNA825I DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111 CABDECPP=00000000 EIBPARM=00000000
DSNA813I DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=80
DSNA810I DSNACA70 TCB=00AFC628 BEFORE IDENTIFY ==============================



And this from the MVS SYSLOG

DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 890
PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION
HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT

and that is it. how do I find out what caused the abnormal termination?





-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----

The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
-----End Original Message-----

-----End Original Message-----

The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

James Campbell

help with stored procedure abend
(in response to Brad Wissink)
Since the last DSNTRACE message in DB8TWLM is
> DSNA810I  DSNACA70 TCB=00AFC628 BEFORE IDENTIFY
I am guessing that either
- DSNTRACE has lost messages - which are in a block that hasn't been externalised. Is it
defined with RECFM=F,LRECL=132?
- something went horribly wrong in the IDENTIFY process. No idea what.

Does DB8TWLM have SYSPRINT, SYSxDUMP and SYSOUT DDs? Anything in the system
log?


James Campbell


On 11 Jan 2018 at 16:55, Wissink, Brad wrote:

>
> The remote server is another MVS lpar and I am only getting the following from the
> MSTR address space.
>  
> DSNX906I  ! DSNX9CAC PROCEDURE OR FUNCTION  230                     
> PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR
> FUNCTION  
> HAS BEEN STOPPED. ASID= 0117 WLM_ENV= DB2WLM_DEFLTT                 
>                                                                      
> DSN3201I  ! ABNORMAL EOT IN PROGRESS FOR USER=DB8TUSR  231          
> CONNECTION-ID=RRSAF CORRELATION-ID=             JOBNAME=DB8TWLM     
> ASID=0117 TCB=00AD1AA0                                              
>  
> Is there somewhere else I can look for more information?
>  
> From: Lizette Koehler [mailto:[login to unmask email]
> Sent: Thursday, January 11, 2018 10:20 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: help with stored procedure abend
>  
> I would think you would need to get logs from the remote server to answer that.  DB2 is
> only reporting on what the remote told it.
>  
> Lizette
>  
>  
> From: Wissink, Brad [mailto:[login to unmask email] ]
> Sent: Thursday, January 11, 2018 8:53 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: help with stored procedure abend
>  
> I saw this earlier and except for the communication error I don´t know what any of that
> means.  So where do I find an explanation of what it means that the remote server `voted
> NO´ or `voted heuristic mixed´?   What causes an `error in their use of commit protocol´?
>  
> From: Chris Hoelscher [mailto:[login to unmask email] ]
> Sent: Wednesday, January 10, 2018 5:00 PM
> To: '[login to unmask email]' <[login to unmask email]>
> Subject: [DB2-L] - RE: help with stored procedure abend
>  
> 00D30109                                                                     
>                                                                               
> Explanation                                                                  
> Phase 1 of a distributed commit failed. One or more remote servers did one of
> the following actions:                                                       
>    o Voted NO                                                                
>    o Voted heuristic mixed                                                   
>    o Experienced a communications error                                      
>    o Made an error in their use of commit protocol                           
>  
> Chris Hoelscher
> Technology Architect, Database Infrastructure Services
> Technology Solution Services
> Description: Description: cid:[login to unmask email]
> 123 East Main Street
> Louisville, KY 40202
> Humana.com
> (502) 476-2538 or 407-7266
>  
> From: Brad Wissink [mailto:[login to unmask email] ]
> Sent: Wednesday, January 10, 2018 5:53 PM
> To: [login to unmask email]
> Subject: [DB2-L] - help with stored procedure abend
>  
> I am working on a stored procedure that is failing and I'm not getting any information on
> why.  The batch application program get the following error message and put out the other
> messages. 
> READY                                                                     
>  DSN SYSTEM(DB2P)                                                         
> DSN                                                                       
>  RUN  PROGRAM(TPDB2TST) PLAN(PPSAP008)       LIB('BJW.PROD1.LOADLIB')     
> DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE
> X'00D30109'  
> DSN                                                                       
>  END                                                                      
> READY                                                                     
> END                                                                       
> WS-SQLCODE AFTER CONNECT = 000000000    
> WS-SQLCODEP AFTER CONNECT = 000000000   
> PSQLSTATE  =                            
> PSQLERRMC  =                            
>                                         
>                                         
> WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS   
> WS-SQLCODE AFTER CALL = 000000430       
> WS-SQLSTATE AFTER CALL = 000038503      
> PSQLCODE   = 000000000                  
> AGENT NAME =                            
> ADDR LINE1 =                            
> ADDR LINE2 =                            
> ADDR CITY  =                            
> ADDR STATE =                            
> ADDR ZIP =                              
> TPDB2IFC CALL RETURN-CODE = 0000        
> the 430 sqlcode says the stored procedure abnormally terminated.
> So from the stored procedure side I get this from DSNTRACE
> DSNA800I  DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT
> R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80   
> DSNA805I  DSNACA00 TCB=00AFC628 CONNECT REQUEST    SSID=DB8T 
> TECBP=18113590  SECBP=18113598  RIBW=181135A0           
> DSNA826I  DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE
> START-UP ECB AT ADDRESS 18113598                         
> DSNA827I  DSNACA00 TCB=00AFC628 AFTER  VALIDITY CHECKING THE
> START-UP ECB WHICH CONTAINS 00000000                     
> DSNA826I  DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE
> TERMINATE ECB AT ADDRESS 18113590                        
> DSNA827I  DSNACA00 TCB=00AFC628 AFTER  VALIDITY CHECKING THE
> TERMINATE ECB WHICH CONTAINS 00000000                    
> DSNA825I  DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111
> CABDECPP=00000000 EIBPARM=00000000                            
> DSNA813I  DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001
> FVLE=0002 PARM=00000000 PCNT=0000                
> DSNA814I  DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000
> RHPC=00000000 QUAL=0001 RSV1=80                  
> DSNA810I  DSNACA70 TCB=00AFC628 BEFORE IDENTIFY
> ==============================                                        
>  
> And this from the MVS SYSLOG
> DSNX906I  ! DSNX9CAC PROCEDURE OR FUNCTION 890                       
> PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR
> FUNCTION   
> HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT                  
> and that is it.   how do I find out what caused the abnormal termination?
>  
>  
>  
> -----End Original Message-----
>

Brad Wissink

help with stored procedure abend
(in response to James Campbell)
I have SYSPRINT, SYSOUT, DSNRRSAF, DSNTRACE, SYSMDUMP and SYSUDUMP.

I get this from SYSPRINT
++ START OF TPDB2SPS STARTING ++ which is the stored procedure program saying it is starting
I get this from DSNTRACE
DSNA800I DSNACA00 TCB=00AD1BE0 ENTERED DSNACA00 ACTION=CONNECT R1=16E75760 CABPTR=800212B8 CABFLAG1=0B CABFLAG2=80
DSNA805I DSNACA00 TCB=00AD1BE0 CONNECT REQUEST SSID=DB8T TECBP=18113590 SECBP=18113598 RIBW=181135A0
DSNA826I DSNACA00 TCB=00AD1BE0 BEFORE VALIDITY CHECKING THE START-UP ECB AT ADDRESS 18113598
DSNA827I DSNACA00 TCB=00AD1BE0 AFTER VALIDITY CHECKING THE START-UP ECB WHICH CONTAINS 00000000
DSNA826I DSNACA00 TCB=00AD1BE0 BEFORE VALIDITY CHECKING THE TERMINATE ECB AT ADDRESS 18113590
DSNA827I DSNACA00 TCB=00AD1BE0 AFTER VALIDITY CHECKING THE TERMINATE ECB WHICH CONTAINS 00000000
DSNA825I DSNACA70 TCB=00AD1BE0 CABSSID=DB8T CABREL=111 CABDECPP=00000000 EIBPARM=00000000
DSNA813I DSNACA70 TCB=00AD1BE0 FRBP=00021450 RAL=00000000 RALE=0001 FVLE=0002 PARM=00000000 PCNT=0000
DSNA814I DSNACA70 TCB=00AD1BE0 RC1=0000 RC2=00000000 FBACK=00000000 RHPC=00000000 QUAL=0001 RSV1=80
DSNA810I DSNACA70 TCB=00AD1BE0 BEFORE IDENTIFY ==============================

And that is it. Nothing more


Brad Wissink| Sr. Systems Programmer
Sammons(r) Financial Group Member Companies
4350 Westown Pkwy | West Des Moines | IA 50266
Phone 515-267-2735 | ext. 33735 | Cell: 515-231-1511

[login to unmask email]<mailto:[login to unmask email]> | www.SammonsFinancialGroup.com http://www.sammonsfinancialgroup.com

From: James Campbell [mailto:[login to unmask email]
Sent: Thursday, January 11, 2018 4:05 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: help with stored procedure abend

Since the last DSNTRACE message in DB8TWLM is
> DSNA810I DSNACA70 TCB=00AFC628 BEFORE IDENTIFY
I am guessing that either
- DSNTRACE has lost messages - which are in a block that hasn't been externalised. Is it defined with RECFM=F,LRECL=132?
- something went horribly wrong in the IDENTIFY process. No idea what.

Does DB8TWLM have SYSPRINT, SYSxDUMP and SYSOUT DDs? Anything in the system log?


James Campbell


On 11 Jan 2018 at 16:55, Wissink, Brad wrote:

>
> The remote server is another MVS lpar and I am only getting the following from the
> MSTR address space.
>
> DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 230
> PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR
> FUNCTION
> HAS BEEN STOPPED. ASID= 0117 WLM_ENV= DB2WLM_DEFLTT
>
> DSN3201I ! ABNORMAL EOT IN PROGRESS FOR USER=DB8TUSR 231
> CONNECTION-ID=RRSAF CORRELATION-ID= JOBNAME=DB8TWLM
> ASID=0117 TCB=00AD1AA0
>
> Is there somewhere else I can look for more information?
>
> From: Lizette Koehler [mailto:[login to unmask email]
> Sent: Thursday, January 11, 2018 10:20 AM
> To: [login to unmask email]<mailto:[login to unmask email]>
> Subject: [DB2-L] - RE: help with stored procedure abend
>
> I would think you would need to get logs from the remote server to answer that. DB2 is
> only reporting on what the remote told it.
>
> Lizette
>
>
> From: Wissink, Brad [mailto:[login to unmask email] <mailto:[login to unmask email]%20> ]
> Sent: Thursday, January 11, 2018 8:53 AM
> To: [login to unmask email]<mailto:[login to unmask email]>
> Subject: [DB2-L] - RE: help with stored procedure abend
>
> I saw this earlier and except for the communication error I don't know what any of that
> means. So where do I find an explanation of what it means that the remote server 'voted
> NO' or 'voted heuristic mixed'? What causes an 'error in their use of commit protocol'?
>
> From: Chris Hoelscher [mailto:[login to unmask email] <mailto:[login to unmask email]%20> ]
> Sent: Wednesday, January 10, 2018 5:00 PM
> To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
> Subject: [DB2-L] - RE: help with stored procedure abend
>
> 00D30109
>
> Explanation
> Phase 1 of a distributed commit failed. One or more remote servers did one of
> the following actions:
> o Voted NO
> o Voted heuristic mixed
> o Experienced a communications error
> o Made an error in their use of commit protocol
>
> Chris Hoelscher
> Technology Architect, Database Infrastructure Services
> Technology Solution Services
> Description: Description: cid:[login to unmask email]
> 123 East Main Street
> Louisville, KY 40202
> Humana.com
> (502) 476-2538 or 407-7266
>
> From: Brad Wissink [mailto:[login to unmask email] <mailto:[login to unmask email]%20> ]
> Sent: Wednesday, January 10, 2018 5:53 PM
> To: [login to unmask email]<mailto:[login to unmask email]>
> Subject: [DB2-L] - help with stored procedure abend
>
> I am working on a stored procedure that is failing and I'm not getting any information on
> why. The batch application program get the following error message and put out the other
> messages.
> READY
> DSN SYSTEM(DB2P)
> DSN
> RUN PROGRAM(TPDB2TST) PLAN(PPSAP008) LIB('BJW.PROD1.LOADLIB')
> DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE
> X'00D30109'
> DSN
> END
> READY
> END
> WS-SQLCODE AFTER CONNECT = 000000000
> WS-SQLCODEP AFTER CONNECT = 000000000
> PSQLSTATE =
> PSQLERRMC =
>
>
> WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS
> WS-SQLCODE AFTER CALL = 000000430
> WS-SQLSTATE AFTER CALL = 000038503
> PSQLCODE = 000000000
> AGENT NAME =
> ADDR LINE1 =
> ADDR LINE2 =
> ADDR CITY =
> ADDR STATE =
> ADDR ZIP =
> TPDB2IFC CALL RETURN-CODE = 0000
> the 430 sqlcode says the stored procedure abnormally terminated.
> So from the stored procedure side I get this from DSNTRACE
> DSNA800I DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT
> R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80
> DSNA805I DSNACA00 TCB=00AFC628 CONNECT REQUEST SSID=DB8T
> TECBP=18113590 SECBP=18113598 RIBW=181135A0
> DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE
> START-UP ECB AT ADDRESS 18113598
> DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE
> START-UP ECB WHICH CONTAINS 00000000
> DSNA826I DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE
> TERMINATE ECB AT ADDRESS 18113590
> DSNA827I DSNACA00 TCB=00AFC628 AFTER VALIDITY CHECKING THE
> TERMINATE ECB WHICH CONTAINS 00000000
> DSNA825I DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111
> CABDECPP=00000000 EIBPARM=00000000
> DSNA813I DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001
> FVLE=0002 PARM=00000000 PCNT=0000
> DSNA814I DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000
> RHPC=00000000 QUAL=0001 RSV1=80
> DSNA810I DSNACA70 TCB=00AFC628 BEFORE IDENTIFY
> ==============================
>
> And this from the MVS SYSLOG
> DSNX906I ! DSNX9CAC PROCEDURE OR FUNCTION 890
> PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR
> FUNCTION
> HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT
> and that is it. how do I find out what caused the abnormal termination?
>
>
>
> -----End Original Message-----
>

-----End Original Message-----

The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

James Campbell

help with stored procedure abend
(in response to Brad Wissink)
I think you'll need to raise a PMR. There seems to be a deep problem.

James Campbell

On 15 Jan 2018 at 20:23, Wissink, Brad wrote:

>
> I have SYSPRINT, SYSOUT, DSNRRSAF, DSNTRACE, SYSMDUMP and SYSUDUMP.  
>  
> I get this from SYSPRINT
> ++ START OF TPDB2SPS STARTING ++        which is the stored procedure program saying it is
> starting
> I get this from DSNTRACE
> DSNA800I  DSNACA00 TCB=00AD1BE0 ENTERED DSNACA00 ACTION=CONNECT
> R1=16E75760 CABPTR=800212B8 CABFLAG1=0B CABFLAG2=80      
> DSNA805I  DSNACA00 TCB=00AD1BE0 CONNECT REQUEST    SSID=DB8T 
> TECBP=18113590  SECBP=18113598  RIBW=181135A0              
> DSNA826I  DSNACA00 TCB=00AD1BE0 BEFORE VALIDITY CHECKING THE
> START-UP ECB AT ADDRESS 18113598                            
> DSNA827I  DSNACA00 TCB=00AD1BE0 AFTER  VALIDITY CHECKING THE START-UP
> ECB WHICH CONTAINS 00000000                        
> DSNA826I  DSNACA00 TCB=00AD1BE0 BEFORE VALIDITY CHECKING THE
> TERMINATE ECB AT ADDRESS 18113590                           
> DSNA827I  DSNACA00 TCB=00AD1BE0 AFTER  VALIDITY CHECKING THE
> TERMINATE ECB WHICH CONTAINS 00000000                       
> DSNA825I  DSNACA70 TCB=00AD1BE0 CABSSID=DB8T CABREL=111
> CABDECPP=00000000 EIBPARM=00000000                               
> DSNA813I  DSNACA70 TCB=00AD1BE0 FRBP=00021450 RAL=00000000 RALE=0001
> FVLE=0002 PARM=00000000 PCNT=0000                   
> DSNA814I  DSNACA70 TCB=00AD1BE0 RC1=0000 RC2=00000000 FBACK=00000000
> RHPC=00000000 QUAL=0001 RSV1=80                     
> DSNA810I  DSNACA70 TCB=00AD1BE0 BEFORE IDENTIFY
> ==============================                                           
>  
> And that is it.  Nothing more
>  
>  
> Brad Wissink|Sr. Systems Programmer
> Sammons® Financial Group Member Companies
> 4350 Westown Pkwy | West Des Moines | IA 50266
> Phone 515-267-2735 | ext. 33735 | Cell: 515-231-1511
>  
> [login to unmask email]  |www.SammonsFinancialGroup.com
>  
> From: James Campbell [mailto:[login to unmask email]
> Sent: Thursday, January 11, 2018 4:05 PM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: help with stored procedure abend
>  
> Since the last DSNTRACE message in DB8TWLM is
> > DSNA810I  DSNACA70 TCB=00AFC628 BEFORE IDENTIFY
> I am guessing that either
> - DSNTRACE has lost messages - which are in a block that hasn't been externalised.  Is it defined
> with RECFM=F,LRECL=132?
> - something went horribly wrong in the IDENTIFY process.  No idea what.
>  
> Does DB8TWLM have SYSPRINT, SYSxDUMP and SYSOUT DDs?  Anything in the system log?
>  
>  
> James Campbell 
>  
>  
> On 11 Jan 2018 at 16:55, Wissink, Brad wrote:
>  
> >
> > The remote server is another MVS lpar and I am only getting the following from the
> > MSTR address space.
> >  
> > DSNX906I  ! DSNX9CAC PROCEDURE OR FUNCTION  230                     
> > PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR
> > FUNCTION  
> > HAS BEEN STOPPED. ASID= 0117 WLM_ENV= DB2WLM_DEFLTT                 
> >                                                                     
> > DSN3201I  ! ABNORMAL EOT IN PROGRESS FOR USER=DB8TUSR  231          
> > CONNECTION-ID=RRSAF CORRELATION-ID=             JOBNAME=DB8TWLM     
> > ASID=0117 TCB=00AD1AA0                                              
> >  
> > Is there somewhere else I can look for more information?
> >  
> > From: Lizette Koehler [mailto:[login to unmask email]
> > Sent: Thursday, January 11, 2018 10:20 AM
> > To: [login to unmask email]
> > Subject: [DB2-L] - RE: help with stored procedure abend
> >  
> > I would think you would need to get logs from the remote server to answer that.  DB2 is
> > only reporting on what the remote told it.
> >  
> > Lizette
> >  
> >  
> > From: Wissink, Brad [mailto:[login to unmask email] ]
> > Sent: Thursday, January 11, 2018 8:53 AM
> > To: [login to unmask email]
> > Subject: [DB2-L] - RE: help with stored procedure abend
> >  
> > I saw this earlier and except for the communication error I don´t know what any of that
> > means.  So where do I find an explanation of what it means that the remote server `voted
> > NO´ or `voted heuristic mixed´?   What causes an `error in their use of commit protocol´?
> >  
> > From: Chris Hoelscher [mailto:[login to unmask email] ]
> > Sent: Wednesday, January 10, 2018 5:00 PM
> > To: '[login to unmask email]' <[login to unmask email]>
> > Subject: [DB2-L] - RE: help with stored procedure abend
> >  
> >00D30109                                                                     
> >                                                                              
> >Explanation                                                                  
> > Phase 1 of a distributed commit failed. One or more remote servers did one of
> > the following actions:                                                       
> >    o Voted NO                                                                
> >    o Voted heuristic mixed                                                   
> >    o Experienced a communications error                                      
> >    o Made an error in their use of commit protocol                           
> >  
> > Chris Hoelscher
> > Technology Architect, Database Infrastructure Services
> > Technology Solution Services
> > Description: Description: cid:[login to unmask email]
> > 123 East Main Street
> > Louisville, KY 40202
> > Humana.com
> > (502) 476-2538 or 407-7266
> >  
> > From: Brad Wissink [mailto:[login to unmask email] ]
> > Sent: Wednesday, January 10, 2018 5:53 PM
> > To: [login to unmask email]
> > Subject: [DB2-L] - help with stored procedure abend
> >  
> > I am working on a stored procedure that is failing and I'm not getting any information on
> > why.  The batch application program get the following error message and put out the other
> > messages. 
> >READY                                                                     
> >  DSN SYSTEM(DB2P)                                                         
> >DSN                                                                       
> >  RUN  PROGRAM(TPDB2TST) PLAN(PPSAP008)       LIB('BJW.PROD1.LOADLIB')     
> > DSNE949E COMMIT PROCESSING ABNORMAL TERMINATION, REASON CODE
> > X'00D30109'  
> >DSN                                                                       
> > END                                                                      
> >READY                                                                     
> >END                                                                       
> > WS-SQLCODE AFTER CONNECT = 000000000    
> > WS-SQLCODEP AFTER CONNECT = 000000000   
> > PSQLSTATE  =                            
> > PSQLERRMC  =                            
> >                                        
> >                                        
> > WSWA-CALL-SP-NAME = PPSSA008.TPDB2SPS   
> > WS-SQLCODE AFTER CALL = 000000430       
> > WS-SQLSTATE AFTER CALL = 000038503      
> > PSQLCODE   = 000000000                  
> > AGENT NAME =                            
> > ADDR LINE1 =                            
> > ADDR LINE2 =                            
> > ADDR CITY  =                            
> > ADDR STATE =                            
> > ADDR ZIP =                              
> > TPDB2IFC CALL RETURN-CODE = 0000        
> > the 430 sqlcode says the stored procedure abnormally terminated.
> > So from the stored procedure side I get this from DSNTRACE
> > DSNA800I  DSNACA00 TCB=00AFC628 ENTERED DSNACA00 ACTION=CONNECT
> > R1=16D42760 CABPTR=800202B8 CABFLAG1=0B CABFLAG2=80   
> > DSNA805I  DSNACA00 TCB=00AFC628 CONNECT REQUEST    SSID=DB8T 
> > TECBP=18113590  SECBP=18113598  RIBW=181135A0           
> > DSNA826I  DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE
> > START-UP ECB AT ADDRESS 18113598                         
> > DSNA827I  DSNACA00 TCB=00AFC628 AFTER  VALIDITY CHECKING THE
> > START-UP ECB WHICH CONTAINS 00000000                     
> > DSNA826I  DSNACA00 TCB=00AFC628 BEFORE VALIDITY CHECKING THE
> > TERMINATE ECB AT ADDRESS 18113590                        
> > DSNA827I  DSNACA00 TCB=00AFC628 AFTER  VALIDITY CHECKING THE
> > TERMINATE ECB WHICH CONTAINS 00000000                    
> > DSNA825I  DSNACA70 TCB=00AFC628 CABSSID=DB8T CABREL=111
> > CABDECPP=00000000 EIBPARM=00000000                            
> > DSNA813I  DSNACA70 TCB=00AFC628 FRBP=00020450 RAL=00000000 RALE=0001
> > FVLE=0002 PARM=00000000 PCNT=0000                
> > DSNA814I  DSNACA70 TCB=00AFC628 RC1=0000 RC2=00000000 FBACK=00000000
> > RHPC=00000000 QUAL=0001 RSV1=80                  
> > DSNA810I  DSNACA70 TCB=00AFC628 BEFORE IDENTIFY
> >==============================                                        
> >  
> > And this from the MVS SYSLOG
> > DSNX906I  ! DSNX9CAC PROCEDURE OR FUNCTION 890                       
> > PPSSA008.TPDB2SPS TERMINATED ABNORMALLY. THE PROCEDURE OR
> > FUNCTION   
> > HAS BEEN STOPPED. ASID= 00F7 WLM_ENV= DB2WLM_DEFLTT                  
> > and that is it.   how do I find out what caused the abnormal termination?
> >  
> >  
> >