IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error using DSNUTILB utility. pls provide inputs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Sat Apr 12, 2008 3:05 am
Reply with quote

Hello all . I am getting the following abend can anyone pls give some clues on how to resolve it

I couldn't find the actual reason of the abend by the dump

jcl Step which is giving abend
-------------------------------------------------
--------------------------------------------------

//PS210 EXEC PGM=DSNUTILB,REGION=2048K,PARM='DB2,LOADTB,',
// COND=(4,LT)
//STEPLIB DD DSN=DNDDB2.DB2.SDSNLOAD,DISP=SHR
//SYSUT1 DD DSN=EVJN.P3.UCS0910.SYSUT1(+1),DISP=(OLD,PASS)
//SORTOUT DD DSN=EVJN.P3.UCS0910.SORTOUT(+1),DISP=(OLD,PASS)
//SYSERR DD DSN=EVJN.P3.UCS0910.SYSERR(+1),DISP=(OLD,PASS)
//SYSMAP DD DSN=EVJN.P3.UCS0910.SYSMAP(+1),DISP=(OLD,PASS)
//SYSDISC DD DSN=EVJN.P3.UCS0910.SYSDISC(+1),DISP=(OLD,PASS)
//SYSREC00 DD DSN=EVJN.P3.UCS0905.D91C21O(0),DISP=SHR
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD DSN=EVJN.P3.UCS0910.DCTSNI(+1),DISP=SHR

-------------------------------------------------------------------------
data in file : EVJN.P3.UCS0910.DCTSNI.G0001V00
--------------------------------------------------------------------------
LOAD DATA RESUME YES LOG NO INDDN SYSREC00 INTO TABLE
EVJNUCS3.DCTSN_STATEMENT (
AC_INTRL_ID POSITION(1:7) DECIMAL ,
SN_CYC_END_DT POSITION(10) DATE EXTERNAL(10) ,
SN_SEQ_NR POSITION(20) SMALLINT,
SN_BLL_CYC_DYS_NR POSITION(22:23) DECIMAL ,
AC_CYC_NR POSITION(24:25) DECIMAL ,
SN_CYC_BGN_DT POSITION(28) DATE EXTERNAL(10)
NULLIF(26)=X'FF',
AC_STAT_CD POSITION(38) CHAR(3) ,
CC_STMT_CD POSITION(41) CHAR(3) ,
SN_AVAIL_LN_AM POSITION(44:51) DECIMAL ,
SN_BLL_REQ_PYMT_AM POSITION(52:59) DECIMAL ,
CC_CR_LN_AM POSITION(60:67) DECIMAL ,
CC_CSH_LN_PT POSITION(68:71) DECIMAL ,
CC_OTH_BAL_AM POSITION(72:79) DECIMAL ,
CC_CASH_BAL_AM POSITION(80:87) DECIMAL ,
CC_PRCH_BAL_AM POSITION(88:95) DECIMAL ,
SN_TOT_FEE_AM POSITION(96:103) DECIMAL ,
SN_TOT_FC_AM POSITION(104:111) DECIMAL ,
SN_TOT_CR_VCHR_AM POSITION(112:119) DECIMAL ,
SN_TOT_PYMT_AM POSITION(120:127) DECIMAL ,
SN_CYC_DELQ_AM POSITION(128:135) DECIMAL ,
CC_MAIL_CD POSITION(136) CHAR(3) ,
CC_MIN_PYMT_DUE_DT POSITION(141) DATE EXTERNAL(10)
NULLIF(139)=X'FF',
SN_OVLN_AM POSITION(151:158) DECIMAL ,
SN_PAST_DUE_AM POSITION(159:166) DECIMAL ,
SN_MIN_PYMT_AM POSITION(167:174) DECIMAL ,
CC_FRG_AM POSITION(175:182) DECIMAL ,
DI_CURR_DQ_AGE_CD POSITION(183:183) DECIMAL ,
SN_TOT_CR_AM POSITION(184:191) DECIMAL ,
CC_SKP_PY_CD POSITION(192) CHAR(1) ,
SN_TRAN_CT POSITION(193:194) DECIMAL ,
SN_AVG_DLY_BAL_AM POSITION(195:202) DECIMAL ,
AC_DSCL_CD POSITION(203) CHAR(6) ,
SN_DSPUTE_TOT_AM POSITION(209:216) DECIMAL ,
AC_PU_OVRD_CD POSITION(217) CHAR(5) ,
SN_CR_ADJ_AM POSITION(222:229) DECIMAL ,
SN_DR_ADJ_AM POSITION(230:237) DECIMAL ,
SN_FEE_CHRG_ADJ_AM POSITION(238:245) DECIMAL ,
SN_PRI_MIN_PYMT_AM POSITION(246:253) DECIMAL ,
SN_PRI_PAST_DUE_AM POSITION(254:261) DECIMAL ,
SN_UPD_PAST_DUE_AM POSITION(262:269) DECIMAL ,
AC_CRD_OUTSTG_CT POSITION(270:271) DECIMAL ,
SN_UPD_TOT_CR_AM POSITION(272:279) DECIMAL ,
SN_UPD_TOT_DB_AM POSITION(280:287) DECIMAL ,
TC_CRT_USR_ID POSITION(288) CHAR(8) ,
TC_CRT_TS POSITION(296) TIMESTAMP EXTERNAL(26) ,
TC_UPDT_USR_ID POSITION(322) CHAR(8) ,
TC_UPDT_TS POSITION(330) TIMESTAMP EXTERNAL(26) ,
SN_CSH_LN_AM POSITION(356:363) DECIMAL ,
SN_AVAIL_CSH_LN_AM POSITION(364:371) DECIMAL ,
AC_SRCE_CD POSITION(372) CHAR(3) ,
AC_PREF_STORE_NM POSITION(375) CHAR(23) ,
CC_RVSAC_BAL_AM POSITION(398:405) DECIMAL ,
SN_BAL_CT POSITION(406:407) DECIMAL ,
SN_PREV_CYC_BAL_AM POSITION(408:415) DECIMAL ,
SN_MAN_TXN_IN POSITION(416) CHAR(1) ,
SN_BALANCE_INFO POSITION(417) VARCHAR )

-----------------------------------------------------------------------
dump of the job. i am getting a max cc 8 in the end
-------------------------------------------------------------------------


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = LOADTB
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - LOAD DATA RESUME YES LOG NO INDDN SYSREC00
DSNU650I :DB2_ DSNURWI - INTO TABLE EVJNUCS3.DCTSN_STATEMENT
DSNU650I :DB2_ DSNURWI - (AC_INTRL_ID POSITION(1:7) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_CYC_END_DT POSITION(10) DATE EXTERNAL(10),
DSNU650I :DB2_ DSNURWI - SN_SEQ_NR POSITION(20) SMALLINT,
DSNU053I :DB2_ DSNURWUF - FIELD 'SN_SEQ_NR' NOT FOUND
DSNU650I :DB2_ DSNURWI - SN_BLL_CYC_DYS_NR POSITION(22:23) DECIMAL,
DSNU650I :DB2_ DSNURWI - AC_CYC_NR POSITION(24:25) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_CYC_BGN_DT POSITION(28) DATE EXTERNAL(10) NULLIF
DSNU650I :DB2_ DSNURWI - AC_STAT_CD POSITION(38) CHAR(3),
DSNU650I :DB2_ DSNURWI - CC_STMT_CD POSITION(41) CHAR(3),
DSNU650I :DB2_ DSNURWI - SN_AVAIL_LN_AM POSITION(44:51) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_BLL_REQ_PYMT_AM POSITION(52:59) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_CR_LN_AM POSITION(60:67) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_CSH_LN_PT POSITION(68:71) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_OTH_BAL_AM POSITION(72:79) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_CASH_BAL_AM POSITION(80:87) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_PRCH_BAL_AM POSITION(88:95) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_TOT_FEE_AM POSITION(96:103) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_TOT_FC_AM POSITION(104:111) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_TOT_CR_VCHR_AM POSITION(112:119) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_TOT_PYMT_AM POSITION(120:127) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_CYC_DELQ_AM POSITION(128:135) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_MAIL_CD POSITION(136) CHAR(3),
DSNU650I :DB2_ DSNURWI - CC_MIN_PYMT_DUE_DT POSITION(141) DATE EXTERNAL(10)
DSNU650I :DB2_ DSNURWI - SN_OVLN_AM POSITION(151:158) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_PAST_DUE_AM POSITION(159:166) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_MIN_PYMT_AM POSITION(167:174) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_FRG_AM POSITION(175:182) DECIMAL,
DSNU650I :DB2_ DSNURWI - DI_CURR_DQ_AGE_CD POSITION(183:183) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_TOT_CR_AM POSITION(184:191) DECIMAL,
DSNU650I :DB2_ DSNURWI - CC_SKP_PY_CD POSITION(192) CHAR(1),
DSNU650I :DB2_ DSNURWI - SN_TRAN_CT POSITION(193:194) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_AVG_DLY_BAL_AM POSITION(195:202) DECIMAL,
DSNU650I :DB2_ DSNURWI - AC_DSCL_CD POSITION(203) CHAR(6),
DSNU650I :DB2_ DSNURWI - SN_DSPUTE_TOT_AM POSITION(209:216) DECIMAL,
DSNU650I :DB2_ DSNURWI - AC_PU_OVRD_CD POSITION(217) CHAR(5),
DSNU650I :DB2_ DSNURWI - SN_CR_ADJ_AM POSITION(222:229) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_DR_ADJ_AM POSITION(230:237) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_FEE_CHRG_ADJ_AM POSITION(238:245) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_PRI_MIN_PYMT_AM POSITION(246:253) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_PRI_PAST_DUE_AM POSITION(254:261) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_UPD_PAST_DUE_AM POSITION(262:269) DECIMAL,
DSNU650I :DB2_ DSNURWI - AC_CRD_OUTSTG_CT POSITION(270:271) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_UPD_TOT_CR_AM POSITION(272:279) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_UPD_TOT_DB_AM POSITION(280:287) DECIMAL,
DSNU650I :DB2_ DSNURWI - TC_CRT_USR_ID POSITION(288) CHAR(8),
DSNU650I :DB2_ DSNURWI - TC_CRT_TS POSITION(296) TIMESTAMP EXTERNAL(26),
DSNU650I :DB2_ DSNURWI - TC_UPDT_USR_ID POSITION(322) CHAR(8),
DSNU650I :DB2_ DSNURWI - TC_UPDT_TS POSITION(330) TIMESTAMP EXTERNAL(26),
DSNU650I :DB2_ DSNURWI - SN_CSH_LN_AM POSITION(356:363) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_AVAIL_CSH_LN_AM POSITION(364:371) DECIMAL,
DSNU650I :DB2_ DSNURWI - AC_SRCE_CD POSITION(372) CHAR(3),
DSNU650I :DB2_ DSNURWI - AC_PREF_STORE_NM POSITION(375) CHAR(23),
DSNU650I :DB2_ DSNURWI - CC_RVSAC_BAL_AM POSITION(398:405) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_BAL_CT POSITION(406:407) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_PREV_CYC_BAL_AM POSITION(408:415) DECIMAL,
DSNU650I :DB2_ DSNURWI - SN_MAN_TXN_IN POSITION(416) CHAR(1),
DSNU650I :DB2_ DSNURWI - SN_BALANCE_INFO POSITION(417) VARCHAR)
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 459
Location: Belgium

PostPosted: Sat Apr 12, 2008 3:54 am
Reply with quote

Quote:
DSNU053I :DB2_ DSNURWUF - FIELD 'SN_SEQ_NR' NOT FOUND

Just read icon_exclaim.gif
Back to top
View user's profile Send private message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Mon Apr 14, 2008 8:38 pm
Reply with quote

Thanks

looked like jargon earlier . makes some sense now
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts REASON 00D70014 in load utility DB2 6
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top