ERROR-141, Missing function parameter

, , ,
1

000007 //********************************************************************
000008 //* ADDED UTILITY ADADBS TO ADD FIELD
000009 //********************************************************************
000010 //** SAVE FILES FROM TSSDN.ADA220DB.BCKUP
000011 //PROCS JCLLIB ORDER=(ADABAST.TEMP.PROCLIB)
000012 //*
000013 //STEP02 EXEC ADAUTILT,UTIL=ADADBS,DBID=220,ADADBID=ADA220,MODE=M
000014 //DDCARD DD DSN=ADABAST.TEMP.COMMON.CNTRL(DBS220M),DISP=SHR
000015 ADADBS NEWFIELD FILE=134
000016 ADADBS FNDEF=‘01,DI,6,A,NU,MU(99)’ CASE-POSTREL-HUB-OFC
000017 ADADBS FNDEF=‘01,DJ,7,P,NU,MU(99)’ CASE-POSTREL-HUB-TIMX-COMP
000018 //DDKARTE DD *
000019 /*

*OUTPUT

A D A D B S: Error occurred during execution:

ERROR-141, Missing function parameter

       Add one of the ADADBS function parameters described                
       in the ADABAS Utilities Manual and rerun the job.

A D A D B S Terminated 2011-12-19 14:12:26

ny help will be appreciated

Thanks

2

http://techcommunity.softwareag.com/ecosystem/documentation/adabas/ada824mfr/adamf/util/adadbs-ReqEx.htm#d0e23042

3

Thanks I added this in JCL and found no error in the submission.

000018 //DDKARTE DD *
000019 ADADBS REFRESH FILE=134
000020 /*

How to check newly created fields?

Thanks

4

http://techcommunity.softwareag.com/ecosystem/documentation/adabas/ada824mfr/adamf/util/adarep-RepSyn.htm

5

  1. Did above JCL create fields?

Earlier I ran the report as below:
What should I search in the output?

//* 00012
//REPORT EXEC ADAUTILT,DBID=220,UTIL=REP,ADADBID=ADA220 00013
//DDTEMPR1 DD DUMMY
//DDSORTR1 DD DUMMY
//DDKARTE DD * 00014
ADAREP NOFILE

6

Here my final JCL. I think its work

***************************** Top of Data ******************************
//TSSDN220 JOB (H1345011000,000,00000000000),ICSDBS.BN58,
// CLASS=A,MSGCLASS=T,REGION=0M,
// NOTIFY=TSSDN
//*
/ROUTE PRINT TECHLIB
//
//*********************************************************************
//* ADDED UTILITY ADADBS TO ADD FIELD
//*********************************************************************
//** SAVE FILES FROM TSSDN.ADA220DB.BCKUP
//PROCS JCLLIB ORDER=(ADABAST.TEMP.PROCLIB)
//*
//STEP02 EXEC ADAUTILT,UTIL=ADADBS,DBID=220,ADADBID=ADA220,MODE=M
//DDCARD DD DSN=ADABAST.TEMP.COMMON.CNTRL(DBS220M),DISP=SHR
//DDKARTE DD *
ADADBS NEWFIELD FILE=134
ADADBS FNDEF=‘01,DI,6,A,NU,MU(99)’ CASE-POSTREL-HUB-OFC
ADADBS FNDEF=‘01,DJ,7,P,NU,MU(99)’ CASE-POSTREL-HUB-TIMX-COMP
ADADBS REFRESH FILE=134
/*
**************************** Bottom of Data ****************************

7

“If NOFILE is specified, the printing of all file and field description information is suppressed.”

8

Thanks

Here I got from job output.
ADADBS FNDEF=‘01,DI,6,A,NU,MU(99)’ *CASE-POSTREL-HUB-OFC
ADADBS FNDEF=‘01,DJ,7,P,NU,MU(99)’ *CASE-POSTREL-HUB-TIMX-COMP

—> The parameters mentioned above are now in effect
for File 134

ADADBS REFRESH FILE=134

—> File 134 refreshed

A D A D B S Terminated normally 2011-12-19 15:24:54

Do I still need to report to verify?

thx

9

Probably not, but still a good opportunity to familiarize yourself with ADAREP output.

10

What is the purpose of ADADBS REFRESH FILE?

11

Dawar,

I recommend you take a DBA Skills class or get some mentoring or one-on-one training before you submit any more JCL.

I take it from the number of questions you posted that you are functioning as a DBA but have no idea the basic purpose of what I would call “beginners” utilities.

You should become familiar with the various ADADBS options before you start running them.

12

This is bad time for USA, no more for training. I need to work on my own. So far I learn on my own plus some get help form forum. I think it is possible to learn if you guys will help me once a while. Every thing is possible, this is my believe.

thanks for your suggestion and please feel free to share ur knowledge once a while. If I am able to learn only one or two new things every day, I hope I will be in better shape in six or 12 months. isn’t?

thanks

13

By training, it doesn’t have to be expensive, formal classes. It can be from a more senior DBA who is helping to show you the ropes.

If you don’t have such a person, and you’re it at your site for being an Adabas DBA, I think your site is in big trouble. You need to bring someone in to help for at least long enough to give you the experience you need if you are going to single-handedly support them.

That’s my professional opinion.

It’s never that bad in the US or anywhere to throw someone to the wolves with the keys to the kingdom.