Abend 0C4000 hex occurred



IBM's flagship relational database management system

Abend 0C4000 hex occurred

Postby NAH_WAH » Wed Mar 17, 2010 4:48 pm

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
NAH_WAH
 
Posts: 9
Joined: Sun Jan 24, 2010 9:01 am
Has thanked: 0 time
Been thanked: 0 time

Re: Abend 0C4000 hex occurred

Postby dick scherrer » Thu Mar 18, 2010 2:29 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Abend 0C4000 hex occurred

Postby NAH_WAH » Thu Mar 18, 2010 3:27 pm

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
NAH_WAH
 
Posts: 9
Joined: Sun Jan 24, 2010 9:01 am
Has thanked: 0 time
Been thanked: 0 time

Re: Abend 0C4000 hex occurred

Postby dick scherrer » Fri Mar 19, 2010 1:14 am

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Abend 0C4000 hex occurred

Postby NAH_WAH » Fri Mar 19, 2010 3:06 pm

Hi,
online via spufi


many thanks for help
NAH_WAH
 
Posts: 9
Joined: Sun Jan 24, 2010 9:01 am
Has thanked: 0 time
Been thanked: 0 time

Re: Abend 0C4000 hex occurred

Postby dick scherrer » Fri Mar 19, 2010 11:58 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Abend 0C4000 hex occurred

Postby NAH_WAH » Mon Mar 22, 2010 3:56 pm

Hi,
i m trying this solution and i keep on touch
again thanks
NAH_WAH
 
Posts: 9
Joined: Sun Jan 24, 2010 9:01 am
Has thanked: 0 time
Been thanked: 0 time

Re: Abend 0C4000 hex occurred

Postby dick scherrer » Tue Mar 23, 2010 12:45 am

Good luck - someone will be here :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Abend 0C4000 hex occurred

Postby NAH_WAH » Wed Mar 24, 2010 11:21 pm

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
NAH_WAH
 
Posts: 9
Joined: Sun Jan 24, 2010 9:01 am
Has thanked: 0 time
Been thanked: 0 time

Re: Abend 0C4000 hex occurred

Postby dick scherrer » Thu Mar 25, 2010 12:21 am

Hello,

Suggest you work with your dba to make sure everything is configured as you need it.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Next

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post