Page 1 of 2

Abend 0C4000 hex occurred

PostPosted: Wed Mar 17, 2010 4:48 pm
by NAH_WAH
Hi,
i can't insert record in my table this my script:
000100 -- ************************                     
000110 DROP TABLESPACE LDAPR10.PERSON;                 
000111 DROP DATABASE  LDAPR10;                         
000120 COMMIT;                                         
000130 --*************************                     
000200 --CREATE THE LDAP DATABASE                       
000300 --*************************                     
000400 CREATE DATABASE LDAPR10 STOGROUP SYSDEFLT;       
000500 -- ********************************             
000600 --CREATE THE LDAP PERSON TABLESPACE             
000700 --*****************************                 
000800  CREATE TABLESPACE PERSON IN LDAPR10             
000900  USING STOGROUP SYSDEFLT                         
001000  BUFFERPOOL BP0;                                 
001100 -- **************************                   
001200 --CREATE THE PERSON  TABLE                       
001300 --***********************                       
001400 CREATE TABLE IBMUSER.PERSON (                   
001500 ID_PERS             INTEGER   NOT NULL,         
001600 NOM                 VARCHAR(10),                 
001700 ADRESS              VARCHAR(20),                 
001800 PRIMARY KEY(ID_PERS))                           
001900 IN LDAPR10.PERSON;                               
001910 CREATE UNIQUE INDEX UXID_PERS                   
001920 ON PERSON (ID_PERS) ;                           
001930 COMMIT;                                         
001940 INSERT INTO PERSON                             
001950 VALUES  (1111,'SAA','AAAAA');   
002000 COMMIT;                           


this is return code
--------+---------+---------+---------+---------+---------+---
-- ************************                                   
DROP TABLESPACE LDAPR10.PERSON;                               
---------+---------+---------+---------+---------+---------+---
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0     
---------+---------+---------+---------+---------+---------+---
DROP DATABASE  LDAPR10;                                       
---------+---------+---------+---------+---------+---------+---
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0     
---------+---------+---------+---------+---------+---------+---
COMMIT;                                                       
---------+---------+---------+---------+---------+---------+---
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0     
---------+---------+---------+---------+---------+---------+---
--*************************                                   
--CREATE THE LDAP DATABASE                                     
--*************************                                   
CREATE DATABASE LDAPR10 STOGROUP SYSDEFLT;                     
---------+---------+---------+---------+---------+---------+---
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0     
---------+---------+---------+---------+---------+---------+---
-- ********************************                           
--CREATE THE LDAP PERSON TABLESPACE                           
--*****************************                               
CREATE TABLESPACE PERSON IN LDAPR10                           
USING STOGROUP SYSDEFLT                                       
BUFFERPOOL BP0;                                               

---------+---------+---------+---------+---------+---------+------
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0         
---------+---------+---------+---------+---------+---------+------
-- **************************                                     
--CREATE THE PERSON  TABLE                                       
--***********************                                         
CREATE TABLE IBMUSER.PERSON (                                     
ID_PERS             INTEGER   NOT NULL,                           
NOM                 VARCHAR(10),                                 
ADRESS              VARCHAR(20),                                 
PRIMARY KEY(ID_PERS))                                             
IN LDAPR10.PERSON;                                               
---------+---------+---------+---------+---------+---------+------
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0         
---------+---------+---------+---------+---------+---------+------
CREATE UNIQUE INDEX UXID_PERS                                     
ON PERSON (ID_PERS) ;                                             
---------+---------+---------+---------+---------+---------+------
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0         
---------+---------+---------+---------+---------+---------+------
COMMIT;                                                           
---------+---------+---------+---------+---------+---------+------
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0         
---------+---------+---------+---------+-------


all sqlcode return =0 just insert he return this message

Abend 0C4000 hex occurred processing command 'DSN     '.



can you help me pls
thanks

Re: Abend 0C4000 hex occurred

PostPosted: Thu Mar 18, 2010 2:29 am
by dick scherrer
Hello,

Is this being executed online via spufi or in a batch job?

Before the insert, include a "select count(*) from person;" and see what is returned.

Re: Abend 0C4000 hex occurred

PostPosted: Thu Mar 18, 2010 3:27 pm
by NAH_WAH
Hi,
SELECT COUNT(*) FROM PERSON;                                   
---------+---------+---------+---------+---------+---------+---
                                                               
---------+---------+---------+---------+---------+---------+---
          0                                                   
DSNE610I NUMBER OF ROWS DISPLAYED IS 1                         
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100   

pls help me
thanks

Re: Abend 0C4000 hex occurred

PostPosted: Fri Mar 19, 2010 1:14 am
by dick scherrer
Hello,

pls help me
We would like to help, but often cannot when requested info is not provided. . .
To repeat:
Is this being executed online via spufi or in a batch job?

Re: Abend 0C4000 hex occurred

PostPosted: Fri Mar 19, 2010 3:06 pm
by NAH_WAH
Hi,
online via spufi


many thanks for help

Re: Abend 0C4000 hex occurred

PostPosted: Fri Mar 19, 2010 11:58 pm
by dick scherrer
You're welcome :)

You may have run out of menory in your online session. . .

Suggest you try to run this in batch specifying REGION=0M on the JOB statement.

Re: Abend 0C4000 hex occurred

PostPosted: Mon Mar 22, 2010 3:56 pm
by NAH_WAH
Hi,
i m trying this solution and i keep on touch
again thanks

Re: Abend 0C4000 hex occurred

PostPosted: Tue Mar 23, 2010 12:45 am
by dick scherrer
Good luck - someone will be here :)

d

Re: Abend 0C4000 hex occurred

PostPosted: Wed Mar 24, 2010 11:21 pm
by NAH_WAH
Hi,
its me again
as you said this probleme out of memory
when i m using batch its same
000100 //INJB  JOB ACT01,'IBMUSER',CLASS=A,NOTIFY=&SYSUID,REGION=0M 
000200 //ALTER   EXEC PGM=IKJEFT01,DYNAMNBR=30                       
000210 //STEPLIB DD DISP=SHR,DSN=DSN810.SDSNLOAD                     
000300 //SYSTSPRT DD  SYSOUT=*                                       
000310 //SYSPRINT DD SYSOUT=*                                       
000400 //SYSTSIN  DD  *                                             
000500 DSN SYSTEM(DB8G)                                             
000600 RUN PROGRAM(DSNTIAD)  PLAN(DSNTIA81) -                       
000700 PARM('RC0') LIBRARY('DSN810.RUNLIB.LOAD')                     
000701 END                                                           
000702 /*                                                           
000703 //SYSIN    DD  *                                             
000710 INSERT INTO  PERSON                                           
000720 VALUES (1,'KOKOKO','BHHHH');                                 


i still looking for any solution
i m using zos v 1.9 and i loadparm 0A82AWM1 i have db2 v8 started i wanna changed to db2 v9 can you help me what loadparm must i start

many thanks for all

Re: Abend 0C4000 hex occurred

PostPosted: Thu Mar 25, 2010 12:21 am
by dick scherrer
Hello,

Suggest you work with your dba to make sure everything is configured as you need it.