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

Roy Boxwell

Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE - FIXED!
is now working...however which one of these PTFs actually fixed it I would
not like to guess:

UK31158, UK31692, UK34655, UK35971, UK35977, UK36119, UK36872, UK37110,
UK37143, UK37292, UK37512, UK37528, UK37604, UK37823, UK37836, UK37972,
UK38139, UK38158, UK38163, UK38239, UK38414, UK38627, UK38634, UK38635,
UK38637, UK38677, UK38709, UK38711, UK38934, UK38947, UK39139, UK39140,
UK39357, UK39400, UK39482, UK39483, UK39497, UK39524, UK39747, UK39783,
UK39795, UK39802, UK39805, UK39835, UK39837, UK39844, UK39849, UK39892,
UK39992, UK40156, UK40163, UK40265, UK40270, UK40287, UK40347, UK40356,
UK40385, UK40498, UK40684, UK40687, UK40717, UK40815, UK40942, UK41007,
UK41212, UK41218, UK41370, UK41681, UK41717, UK41817, UK41931, UK41932,
UK41933, UK41934, UK41941, UK41942, UK42119, UK42187, UK42189, UK42199,
UK42229, UK42300, UK42313, UK42322, UK42360, UK42385, UK42409, UK42421,
UK42448, UK42455, UK42482, UK42640, UK42656, UK42715, UK42719, UK42733,
UK42749, UK42760, UK42812, UK42813, UK42830, UK42838, UK42849, UK42850,
UK42873, UK42929, UK42961, UK43130, UK43190, UK43205, UK43261, UK43291,
UK43397, UK43504, UK43576, UK43584, UK43601, UK43608, UK43680, UK43683,
UK43748, UK43794, UK43823, UK43895, UK43929, UK43948, UK43962, UK43992,
UK44009, UK44014, UK44051, UK44081, UK44120, UK44258, UK44300, UK44440,
UK44488, UK44496, UK44603, UK44770, UK44822, UK44834, UK44898, UK44899,
UK44930, UK44934, UK44958, UK44968, UK44980, UK44982, UK44984, UK45000,
UK45013, UK45021, UK45049, UK45062, UK45067, UK45144, UK45195, UK45208,
UK45282, UK45310, UK45349, UK45486, UK45563, UK45568, UK45587, UK45597,
UK45623, UK45627, UK45641, UK45685, UK45706, UK45757, UK45848, UK45881,
UK45947, UK45981, UK46073, UK46078, UK46088, UK46095, UK46097, UK46165,
UK46218, UK46265, UK46277, UK46348, UK46365, UK46412, UK46416, UK46441,
UK46488, UK46502, UK46527, UK46552, UK46612, UK46669, UK46676, UK46678,
UK46709, UK46726, UK46735, UK46741, UK46743, UK46781, UK46796, UK46839,
UK46854, UK46982, UK47029, UK47107, UK47159, UK47194, UK47269, UK47271,
UK47287, UK47354, UK47412, UK47480, UK47499, UK47503, UK47505, UK47618,
UK47619, UK47678, UK47681, UK47811, UK47817, UK47842, UK47888, UK47920,
UK48030, UK48058, UK48127, UK48186, UK48196, UK48297, UK48381, UK48389,
UK48422, UK48540, UK48607, UK48623, UK48681, UK48725, UK48777, UK48807,
UK48884, UK48946, UK49012, UK49118, UK49165, UK49277, UK49498, UK49581,
UK49588, UK49710, UK49761, UK49930, UK49946, UK49952, UK49969, UK50056,
UK50085, UK50169, UK50210, UK50269, UK50382, UK50401, UK50405, UK50412,
UK50413, UK50565, UK50894, UK50908, UK50932, UK50940, UK50966, UK51177,
UK51202, UK51205, UK51548, UK51613, UK51619, UK51664, UK51984, UK52600,
UK53313, UK53711


....hmmm..... :)



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




"Mortensen, Danial" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
08.02.2010 17:03
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






You may want to see if this is on your system

APAR Identifier ...... PK65805 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)



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.



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 *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________

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