Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE

Roy Boxwell

Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line it works
fine....
I have looked in the apar database but found nothing...any ideas? (BTW it
works fine in DB2 V7 and DB2 V8)


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Todd Burch

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Roy Boxwell)
What module? What offset? Can you post the full dump title?

(Or, just open a PMR!)

Thanks, Todd
DB2 Level 2


On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:



Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if
you comment out the 16th (clue here perhaps??) "OR COLG " line it
works fine....
I have looked in the apar database but found nothing...any ideas? (BTW
it works fine in DB2 V7 and DB2 V8)


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Roy Boxwell

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Todd Burch)
sadly as a"partner developer" I cannot open a pmr for DB2 V9 - It does not
dump it just does this online SPUFI

Abend 0C4000 hex occurred processing command 'DSN '.
***


and in batch when the module is bound

IKJ56641I DSN ENDED DUE TO ERROR+
IKJ56641I SYSTEM ABEND CODE 0C4 REASON CODE 00000038 PSW
077C00018EFE5F9E ASIDS: HOME = 002F PRIMARY = 0062 SECONDARY = 0062

No matter which DD cards I add I get no more data and nothing is in the
MSTR apart from this

DSN3201I -S91A ABNORMAL EOT IN PROGRESS FOR 720
USER=BOXWELL CONNECTION-ID=TSO CORRELATION-ID=BOXWELL JOBNAME=BOXWELL
ASID=0072 TCB=00869CF0


so no ofset no module nothing!!! Very very bizarre...



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Todd Burch <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
29.01.2010 14:59
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE






What module? What offset? Can you post the full dump title?

(Or, just open a PMR!)

Thanks, Todd
DB2 Level 2


On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:



Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line it works
fine....
I have looked in the apar database but found nothing...any ideas? (BTW it
works fine in DB2 V7 and DB2 V8)




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

David Simpson

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Roy Boxwell)
This works fine on my V9 system in SPUFI... no errors.



______________________________________________________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | [login to unmask email]

For more information about Themis, visit www.themisinc.com < http://www.themisinc.com/ >



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Friday, January 29, 2010 2:31 AM
To: [login to unmask email]
Subject: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE





Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you comment out the 16th (clue here perhaps??) "OR COLG " line it works fine....
I have looked in the apar database but found nothing...any ideas? (BTW it works fine in DB2 V7 and DB2 V8)


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

________________________________

IDUG - The Worldwide DB2 User Community! < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Chris Tee

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to David Simpson)

Roy

have you tried running an EREP report to see if anything was written to LOGREC?

Date: Fri, 29 Jan 2010 15:49:02 +0100
From: [login to unmask email]
Subject: Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
To: [login to unmask email]



sadly as a"partner developer"
I cannot open a pmr for DB2 V9 - It does not dump it just does this online
SPUFI



Abend 0C4000 hex occurred processing
command 'DSN '.

***











and in batch when the module is bound



IKJ56641I DSN ENDED
DUE TO ERROR+



IKJ56641I SYSTEM ABEND CODE 0C4
REASON CODE 00000038 PSW 077C00018EFE5F9E ASIDS: HOME = 002F
PRIMARY = 0062 SECONDARY = 0062



No matter which DD cards I add I get
no more data and nothing is in the MSTR apart from this



DSN3201I -S91A ABNORMAL EOT IN
PROGRESS FOR 720


USER=BOXWELL CONNECTION-ID=TSO CORRELATION-ID=BOXWELL
JOBNAME=BOXWELL

ASID=0072 TCB=00869CF0








so no ofset no module nothing!!! Very
very bizarre...







Roy Boxwell

SOFTWARE ENGINEERING GMBH

-Product Development-

Robert-Stolz-Straße 5

40470 Düsseldorf/Germany

Tel. +49 (0)211 96149-675

Fax +49 (0)211 96149-32

Email: [login to unmask email]

http://www.seg.de



Software Engineering GmbH

Amtsgericht Düsseldorf, HRB 37894

Geschäftsführung: Siegfried Fürst, Gerhard Schubert










Todd Burch <[login to unmask email]>


Gesendet von: IDUG DB2-L <[login to unmask email]>
29.01.2010 14:59



Bitte antworten an

IDUG DB2-L <[login to unmask email]>







An
[login to unmask email]


Kopie




Thema
Re: [DB2-L] Abend S0C4 in
DB2 z/OS V9 with OR and NOT LIKE















What module? What offset? Can you post the
full dump title?



(Or, just open a PMR!)



Thanks, Todd

DB2 Level 2





On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:







Hi!



I have this little SQL



--DROP TABLE BOXWELL.BADTAB ;


--COMMIT ;



CREATE TABLE BOXWELL.BADTAB


(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL


,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL


,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL


,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL


,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL


,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL


,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL


,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;


COMMIT ;



SELECT COUNT(*) FROM BOXWELL.BADTAB


WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'


OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'


OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'


OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'


OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'


OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'


OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'


OR COLF NOT LIKE '&%'


OR COLG NOT LIKE '&%'


;





By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line
it works fine....

I have looked in the apar database but found nothing...any ideas? (BTW
it works fine in DB2 V7 and DB2 V8)










The IDUG DB2-L Listserv is only part of your membership
in IDUG. If you are not already an IDUG member, please
register here.









The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.


_________________________________________________________________
Be one of the first to try Windows Live Mail.
http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Jeff Frazier

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Chris Tee)
Just a stab in the dark but is it going parallel ?
Jeff



David Simpson <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
01/29/2010 10:46 AM
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE






This works fine on my V9 system in SPUFI… no errors.

______________________________________________________________________________

David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 |
[login to unmask email]
For more information about Themis, visit www.themisinc.com

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Friday, January 29, 2010 2:31 AM
To: [login to unmask email]
Subject: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE



Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line it works
fine....
I have looked in the apar database but found nothing...any ideas? (BTW it
works fine in DB2 V7 and DB2 V8)


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


<span style="font-size:78%;"><span style="font-family:arial;"><strong>Notice:</strong> This e-mail message and its attachments are the property of Wendy's/Arby's Group Inc. </span>
<span style="font-family:arial;">or one of its subsidiaries and may contain confidential or legally privileged information intended</span>
<span style="font-family:arial;">solely for the use of the addressee(s). If you are not an intended recipient, then any use, copying or</span>
<span style="font-family:arial;">distribution of this message or its attachments is strictly prohibited. If you received this message in</span>
<span style="font-family:arial;">error, please notify the sender and delete this message entirely from your system.</span></span>

Phil Grainger

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Bruce Lightsey)
Sorry Roy, but it works fine for me too…..



Phil Grainger

Grainger Database Solutions Ltd

_____

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David Simpson
Sent: 29 January 2010 15:44
To: [login to unmask email]
Subject: Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE



This works fine on my V9 system in SPUFI… no errors.



cid:[login to unmask email]__________________________________________
____________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 |
[login to unmask email]

For more information about Themis, visit www.themisinc.com
< http://www.themisinc.com/ >



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Friday, January 29, 2010 2:31 AM
To: [login to unmask email]
Subject: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE





Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line it works
fine....
I have looked in the apar database but found nothing...any ideas? (BTW it
works fine in DB2 V7 and DB2 V8)


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

_____

< http://www.idug.org/db2-north-america-conference/index.html > IDUG - The
Worldwide DB2 User Community!

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.
< http://www.idug.org/register >


_____

< http://www.idug.org/db2-north-america-conference/index.html > IDUG - The
Worldwide DB2 User Community!

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Bruce Lightsey

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Jeff Frazier)
Last time I had this, the region for my TSO session was too small - changed
it to 8M and have not repeated that particular error since ( lots of others
but, not that particular one )





Roy Boxwell
<[login to unmask email]
> To
Sent by: IDUG [login to unmask email]
DB2-L cc
<[login to unmask email]
ORG> Subject
Re: [DB2-L] Abend S0C4 in DB2 z/OS
V9 with OR and NOT LIKE
01/29/2010 08:49
AM


Please respond to
IDUG DB2-L
<[login to unmask email]
2-L.ORG>







sadly as a"partner developer" I cannot open a pmr for DB2 V9 - It does not
dump it just does this online SPUFI

Abend 0C4000 hex occurred processing command 'DSN '.
***


and in batch when the module is bound

IKJ56641I DSN ENDED DUE TO ERROR+

IKJ56641I SYSTEM ABEND CODE 0C4 REASON CODE 00000038 PSW
077C00018EFE5F9E ASIDS: HOME = 002F PRIMARY = 0062 SECONDARY = 0062

No matter which DD cards I add I get no more data and nothing is in the
MSTR apart from this

DSN3201I -S91A ABNORMAL EOT IN PROGRESS FOR 720
USER=BOXWELL CONNECTION-ID=TSO CORRELATION-ID=BOXWELL JOBNAME=BOXWELL
ASID=0072 TCB=00869CF0


so no ofset no module nothing!!! Very very bizarre...



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert



Todd Burch <[login to unmask email]>
Gesendet von: IDUG DB2-L
<[login to unmask email]> An
[login to unmask email]
Kopie
29.01.2010 14:59
Thema
Re: [DB2-L] Abend S0C4 in DB2
Bitte antworten an z/OS V9 with OR and NOT LIKE
IDUG DB2-L
<[login to unmask email]>










What module? What offset? Can you post the full dump title?

(Or, just open a PMR!)

Thanks, Todd
DB2 Level 2


On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:



Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line it works
fine....
I have looked in the apar database but found nothing...any ideas? (BTW it
works fine in DB2 V7 and DB2 V8)





IDUG - The Worldwide DB2 User Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.






(Embedded image moved to file: pic28980.jpg)IDUG - The Worldwide DB2 User
Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Roy Boxwell

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Phil Grainger)
managed to get this extra data

DUMP TITLE=S91A,ABND=0C4-00000038,U=HENN ,M=(N),C=910.RDS -R
SCTCACH,M=DSNTFRCV,LOC=DSNXGRDS.DSNXODFB+3B1A






Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Todd Burch <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
29.01.2010 14:59
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE






What module? What offset? Can you post the full dump title?

(Or, just open a PMR!)

Thanks, Todd
DB2 Level 2


On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:



Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you
comment out the 16th (clue here perhaps??) "OR COLG " line it works
fine....
I have looked in the apar database but found nothing...any ideas? (BTW it
works fine in DB2 V7 and DB2 V8)




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
** Your only source for independent, unbiased, and trusted DB2 information.

_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Dan Mortensen

Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
(in response to Roy Boxwell)
You may want to see if this is on your system

APAR Identifier ...... PK65805 < https://www-304.ibm.com/ibmlink/sis/viewAparDoc.wss?context=aparAndUsage&searchWords=dsnxodfb&documentIds=PK65805&lc=en&cc=US > Last Changed ........ 08/09/02
ABEND0C4 RC38 IN DSNXODFB+3B1A MAY OCCUR ON BIND OF A QUERY
USING A LIKE PREDICATE AND INDEX ON EXPRESSION

Dan Mortensen Sr. Systems DBA


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Sunday, February 07, 2010 11:55 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE


managed to get this extra data

DUMP TITLE=S91A,ABND=0C4-00000038,U=HENN ,M=(N),C=910.RDS -R
SCTCACH,M=DSNTFRCV,LOC=DSNXGRDS.DSNXODFB+3B1A






Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert


Todd Burch <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>

29.01.2010 14:59
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An

[login to unmask email]

Kopie

Thema

Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE







What module? What offset? Can you post the full dump title?

(Or, just open a PMR!)

Thanks, Todd
DB2 Level 2


On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:



Hi!

I have this little SQL

--DROP TABLE BOXWELL.BADTAB ;
--COMMIT ;
CREATE TABLE BOXWELL.BADTAB
(COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL
,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL
,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL
,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL
,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL
,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL
,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL
,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ;
COMMIT ;
SELECT COUNT(*) FROM BOXWELL.BADTAB
WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%'
OR COL3 NOT LIKE '&%' OR COL4 NOT LIKE '&%'
OR COL5 NOT LIKE '&%' OR COL6 NOT LIKE '&%'
OR COL7 NOT LIKE '&%' OR COL8 NOT LIKE '&%'
OR COL9 NOT LIKE '&%' OR COLA NOT LIKE '&%'
OR COLB NOT LIKE '&%' OR COLC NOT LIKE '&%'
OR COLD NOT LIKE '&%' OR COLE NOT LIKE '&%'
OR COLF NOT LIKE '&%'
OR COLG NOT LIKE '&%'
;

By me in Spufi, or in a program when bound, it abends S0C4 - Now, if you comment out the 16th (clue here perhaps??) "OR COLG " line it works fine....
I have looked in the apar database but found nothing...any ideas? (BTW it works fine in DB2 V7 and DB2 V8)

________________________________

[cid:_2_0609A4D406099FCC00207DD4C12576C4 ] < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



________________________________

[ http://www.idug.org/partners/www/images/4992e0ad2d01c9c12dd8a4e7a161cd08.gif ] < http://www.idug.org/top-spotlight/mentor.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
** Your only source for independent, unbiased, and trusted DB2 information.

_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L