Adalodp

, ,
1

Tipping my foot into Adabas and was trying to install Adabas 8.6.1 by following the documentation. I am up to ADALODP and encountered issue which need some guidance.

Product/components used and version/fix level:

Adabas 8.6.1

Detailed explanation of the problem:

ADALODP LODPERS U0035

A D A L O D V8.6 SP1 DBID = 00012 Started 2025-03-26 14:45:24

Parameters:

  • ADALOD LOAD FILE=<PERSFILE>,NAME='PERSONNEL-BASE',                       

  • LOBFILE=<LOBFILE>                                                        

  • <LOBFILE>=LOB file number  <PERSFILE>=Personal base number

ADALOD LOAD FILE=4,NAME=‘PERSONNEL-BASE’,LOBFILE=5
ADALOD MAXISN=2000,DSSIZE=90B,UISIZE=15B,NISIZE=70B
ADALOD DSDEV=3390,ISNREUSE=NO,INDEXCOMPRESSION=YES
ADALOD SORTSIZE=100,TEMPSIZE=100,SORTDEV=3390,TEMPDEV=3390

Function to be executed:

Load File Number 4 (PERSONNEL-BASE )
into database 00012 (ADATST12 )

A D A L O D: Error occurred during execution:

ERROR-134, Incorrect FDT found in input dataset

         O  The FDT expected in the first record is missing, or            
         O  the FDT does not satisfy the rules.                            
                                                                           
       Check whether the input data set is valid.                          
       Supply a correct input dataset and rerun the job.

A D A L O D Terminated 2025-03-26 14:45:24

Error messages / full error message screenshot / log file:

As above

Question related to a free trial, or to a production (customer) instance?

Production customer, I just join Adabas team and learning.

2

LOAD utility is expecting a file that is compressed.

It would either be output of Compress or Unload.

Sounds like you are trying to LOAD a flat file.

Just a suggestion.

Eugene (Gene) Miklovich

ADABAS/NATURAL Systems Support and DBA

Cell: 916-202-7047

Normal Hours: 8am-4pm E.T.

Please call or text if assistance needed outside these hours.

3

Thanks for your feedback.
I am following the steps and I think the sample file provided do not have a header.
Any other help will be appreciated.
Thanks.

4

Can you supply the link to the documentation that you are following? That would help clarify what you are missing. There should be an input file //DEBAND DD statement that points to the input file - is that in your JCL? A copy and paste of your JCL would also help.

Is this the installation procedure you are following? Installing Adabas for z/OS, which has more details at Installing Adabas for z/OS (may be a different database version level, but similar content). If so, have you run the preceding ADALODE, ADALODV, ADALODM jobs successfully? if the “sample file” you are loading exists, does it have any content (try viewing with ISPF Browse utility).

The ADALODP sample job has 2 steps: compress and load (likely 2 load steps - base file, then LOB file). Your messages appear to come form the load step - the sample file would be supplied to the compress (ADACMP) step //DDEBAND DD and the output from ADACMP would be in //DDAUSBA - that output would be the input dataset to ADALOD //DDEBAND. The //DDAUSB1 output would be used as input to the second load step for the LOB file.

5

Hello,

I’m on step 8
8 Load the demonstration files with the ADALODE, ADALODV, ADALODM, and ADALODP jobs.
Completed ADALODE,ADALODV and ADALODM.
I tried to upload my job output but encountered this pop up saying Sorry, new user can not upload attachments and links

6

I will cut and paste the job output here
J E S 2 J O B L O G – S Y S T E M D E V L – N O D E J E S 2 D E V L

14.45.24 JOB21226 ---- WEDNESDAY, 26 MAR 2025 ----
14.45.24 JOB21226 IRR010I USERID N007503 IS ASSIGNED TO THIS JOB.
14.45.24 JOB21226 ICH70001I N007503 LAST ACCESS AT 14:15:44 ON WEDNESDAY, MARCH 26, 2025
14.45.24 JOB21226 $HASP373 N0075036 STARTED - WLM INIT - SRVCLASS BATHIGH - SYS DEVL
14.45.24 JOB21226 IEF403I N0075036 - STARTED - TIME=14.45.24
14.45.25 JOB21226 IEF188I PROBLEM PROGRAM ATTRIBUTES ASSIGNED
14.45.25 JOB21226 +ADAU7C ICS V3.2.1.0/r23060/2023-06-05 INITIALIZED
14.45.25 JOB21226 GSDMV20I JOBNAME- --STEP-- -PSTEP-- CCODE ELAPSED-TIME -CPU-TIME-
14.45.25 JOB21226 GSDMV21I N0075036 CMP 0 00:00:00 0.07S
14.45.25 JOB21226 IEF188I PROBLEM PROGRAM ATTRIBUTES ASSIGNED
14.45.25 JOB21226 IEF450I N0075036 LODPERS - ABEND=S000 U0035 REASON=00000000 230
230 TIME=14.45.25
14.45.25 JOB21226 GSDMV21I N0075036 LODPERS U0035 00:00:00 0.03S
14.45.25 JOB21226 GSDMV21I N0075036 LODPLOB FLUSH 00:00:00 0.00S
14.45.25 JOB21226 IEF404I N0075036 - ENDED - TIME=14.45.25
14.45.25 JOB21226 GSDMV22I -N0075036 ENDED. TOTAL CPU TIME= 0.10S TOTAL ELAPSED TIME= 0.64S
14.45.25 JOB21226 $HASP395 N0075036 ENDED - ABEND=U0035
------ JES2 JOB STATISTICS ------

A D A L O D V8.6 SP1 DBID = 00012 Started 2025-03-26 14:45:24

Parameters:

  • ADALOD LOAD FILE=<PERSFILE>,NAME='PERSONNEL-BASE',                             

  • LOBFILE=<LOBFILE>                                                              

  • <LOBFILE>=LOB file number  <PERSFILE>=Personal base number

ADALOD LOAD FILE=4,NAME=‘PERSONNEL-BASE’,LOBFILE=5
ADALOD MAXISN=2000,DSSIZE=90B,UISIZE=15B,NISIZE=70B
ADALOD DSDEV=3390,ISNREUSE=NO,INDEXCOMPRESSION=YES
ADALOD SORTSIZE=100,TEMPSIZE=100,SORTDEV=3390,TEMPDEV=3390

Function to be executed:

Load File Number 4 (PERSONNEL-BASE )
into database 00012 (ADATST12 )

A D A L O D: Error occurred during execution:

ERROR-134, Incorrect FDT found in input dataset

         O  The FDT expected in the first record is missing, or            
         O  the FDT does not satisfy the rules.                            
                                                                           
       Check whether the input data set is valid.                          
       Supply a correct input dataset and rerun the job.

A D A L O D Terminated 2025-03-26 14:45:24

YES, I got the …PERC dataset from tape

Command ===>
*********************************************************** Top of Data ****
ADAH..E…j…j50005800…ë.Ñ..?.>.Á…
ADAH..E…þ…þ50005600…ç.Í..Â.Á.Ê.È.?..
ADAH..E…j…j50005500… .%.Á.Ì. .>.À.Ê.Z…
ADAH..E…j…j50005300…á.%.Ñ.Ë./.Â.Á.È.Ç…
ADAH..E…j…j50004900… .%.Â.Á.Ê.È…
ADAH..E…j…j50004600…â.Á.Ê.>./.Ê.À…
ADAH..E…j…j50004300…(.Ñ.Ä.Ç.Á.%.Á…
ADAH..E…j…j50004200…â.Á.Ê.>./.Ê.À…
ADAH..E…j…j50004100…ê.?.Â.Á.Ê.È…
ADAH..E…j…j50004000…¢.Á./.>…
ADAH..E…þ…þ50003800…à./.>.Ñ.Á.%…
ADAH..E…þ…þ50006900…&./.È.Ê.Ñ.Ä.,…
ADAH..E…þ…þ50007600…¢.Á./.>…(./.Ê.Ñ.Á..
ADAH..E…j…j50003700…<.?.Í.Ñ.Ë…

7

Could it be the …PERC dataset provide do not have the FDT ?

8

Please re-read my earlier post.

  • supply a copy of the JCL. Not the output.
  • your JES listing shows one job step. As I mentioned, the ADALODP job has 3 steps: a compress (ADACMP) and 2 load (ADALOD) steps. Your JES listing shows that you are only doing a load, so you are missing the ADACMP step.

All the prior jobs you ran were just ADALOD jobs. ADALODP is different because you have to run a compress on the flat file data and the FDT is supplied as input to the ADACMP step via the DDKARTE DD. Once ADACMP is done, its outputs (DDAUSBA, DDAUSB1) are used as inputs to the ADALOD steps.

9

As I am still unable to upload file. Here is the cut and paste of the JCL
//ADALODP1 JOB (TSSDB1200,AS12),‘ADABAS’,MSGCLASS=X,
// CLASS=S,MSGLEVEL=(1,1),NOTIFY=&SYSUID,
// REGION=0M
//*
//* ADALODP: Compress and load the Personnel Base and
//* LOB Demo Files
//*
//* Note: The segment records for the LOB file will be maximally
//* sized according to the DEVICE specified in the ADARUN card.
//* If the LOB File is loaded into a different DATA storage
//* device specify LOBDEVICE in the ADACMP parameters to
//* get the best segmentation.
//*
//CMP EXEC PGM=ADARUN
//STEPLIB DD DISP=SHR,DSN=SYS1.ADABASY.LOAD
// DD DISP=SHR,DSN=SYS1.ADABASY.ICS.LOAD
//*
//TZINFO DD DISP=SHR,DSN=SYS1.ADABASY.TZ00
//DDDRUCK DD SYSOUT=X
//DDPRINT DD SYSOUT=X
//SYSUDUMP DD SYSOUT=X
//DDEBAND DD DISP=OLD,DSN=SYS1.ADABASY.PERC
//DDAUSBA DD DSN=ADABAS.TEST.ADATST12.PERS,
// UNIT=3390,
// VOL=SER=MFDT00,SPACE=(TRK,(200,10),RLSE),DISP=(NEW,KEEP)
//DDAUSB1 DD DSN=ADABAS.TEST.ADATST12.PERL,
// UNIT=3390,
// VOL=SER=MFDT00,SPACE=(TRK,(200,10),RLSE),DISP=(NEW,KEEP)
//DDFEHL DD DISP=(NEW,KEEP),DSN=ADABAS.TEST.ADATST12.FEHL,
// VOL=SER=MFDT00,SPACE=(TRK,1),UNIT=3390
//DDCARD DD *
ADARUN PROG=ADACMP,MODE=MULTI,SVC=250,DEVICE=3390,DBID=012
/*
//DDKARTE DD DISP=SHR,DSN=SYS1.ADABASY.JOBS(FDTPERS)
//*
//LODPERS EXEC PGM=ADARUN
//STEPLIB DD DISP=SHR,DSN=SYS1.ADABASY.LOAD
//*
//DDASSOR1 DD DISP=SHR,DSN=ADABAS.TEST.ADATST12.ASSO
//DDDATAR1 DD DISP=SHR,DSN=ADABAS.TEST.ADATST12.DATA
//DDWORKR1 DD DISP=SHR,DSN=ADABAS.TEST.ADATST12.WORK
//DDTEMPR1 DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.TEMP
//DDSORTR1 DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.SORT
//DDEBAND DD DISP=OLD,DSN=SYS1.ADABASY.PERC
//DDDRUCK DD SYSOUT=X
//DDPRINT DD SYSOUT=X
//SYSUDUMP DD SYSOUT=X
//DDCARD DD *
ADARUN PROG=ADALOD,MODE=MULTI,SVC=250,DEVICE=3390,DBID=012
/*
//DDKARTE DD *

  • ADALOD LOAD FILE=<PERSFILE>,NAME='PERSONNEL-BASE',                 

  • LOBFILE=<LOBFILE>                                                  

  • <LOBFILE>=LOB file number  <PERSFILE>=Personal base number

ADALOD LOAD FILE=4,NAME=‘PERSONNEL-BASE’,LOBFILE=5
ADALOD MAXISN=2000,DSSIZE=90B,UISIZE=15B,NISIZE=70B
ADALOD DSDEV=3390,ISNREUSE=NO,INDEXCOMPRESSION=YES
ADALOD SORTSIZE=100,TEMPSIZE=100,SORTDEV=3390,TEMPDEV=3390
//ADALOD SORTSIZE=27994,TEMPSIZE=27994,SORTDEV=3390,TEMPDEV=3390
//ADALOD SORTSIZE=8904,TEMPSIZE=8904,SORTDEV=3390,TEMPDEV=3390
//ADALOD SORTSIZE=200,TEMPSIZE=200,SORTDEV=3390,TEMPDEV=3390
/
//
//LODPLOB EXEC PGM=ADARUN
//STEPLIB DD DISP=SHR,DSN=SYS1.ADABASY.LOAD
//
//DDASSOR1 DD DISP=SHR,DSN=ADABAS.TEST.ADATST12.ASSOR1
//DDDATAR1 DD DISP=SHR,DSN=ADABAS.TEST.ADATST12.DATAR1
//DDWORKR1 DD DISP=SHR,DSN=ADABAS.TEST.ADATST12.WORKR1
//DDTEMPR1 DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.TEMPR1
//DDSORTR1 DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.SORTR1
//DDEBAND DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.PERL
//DDDRUCK DD SYSOUT=X
//DDPRINT DD SYSOUT=X
//SYSUDUMP DD SYSOUT=X
//DDCARD DD *
ADARUN PROG=ADALOD,MODE=MULTI,SVC=250,DEVICE=3390,DBID=012
/*
//DDKARTE DD *
*ADALOD LOAD FILE=
*ADALOD LOB,NAME=‘PERSONNEL-LOB’,BASEFILE=

  • <LOBFILE>=LOB file number  <PERSFILE>=Personal base number

ADALOD LOAD FILE=5,LOB,
ADALOD NAME=‘PERSONNEL-LOB’,BASEFILE=4
ADALOD MAXISN=2000,DSSIZE=1200B,UISIZE=5B,NISIZE=10B
ADALOD DSDEV=3390,ISNREUSE=NO,INDEXCOMPRESSION=YES
ADALOD SORTSIZE=200,TEMPSIZE=200,SORTDEV=3390,TEMPDEV=3390
//

10

SYS1.ADABASY.PERC is the DDEBAND input for the ADACMP step. You are using it as input to the ADALOD step (also DDEBAND) instead of the output file from ADACMP (DDAUSBA).

On the first ADALOD step (LODPERS) your DDEBAND needs to be
//DDEBAND DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.PERS

11

Thanks.
Change
//DDEBAND DD DISP=OLD,DSN=SYS1.ADABASY.PERS
to
//DDEBAND DD DISP=OLD,DSN=ADABAS.TEST.ADATST12.PERS

Reran
09.49.32 JOB22361 ---- FRIDAY, 28 MAR 2025 ----
09.49.32 JOB22361 IRR010I USERID N007503 IS ASSIGNED TO THIS JOB.
09.49.32 JOB22361 ICH70001I N007503 LAST ACCESS AT 09:22:22 ON FRIDAY, MARCH 28, 2025
09.49.32 JOB22361 $HASP373 N0075036 STARTED - WLM INIT - SRVCLASS BATHIGH - SYS DEVL
09.49.32 JOB22361 IEF403I N0075036 - STARTED - TIME=09.49.32
09.49.32 JOB22361 IEF188I PROBLEM PROGRAM ATTRIBUTES ASSIGNED
09.49.32 JOB22361 +ADAU7C ICS V3.2.1.0/r23060/2023-06-05 INITIALIZED
09.49.33 JOB22361 GSDMV20I JOBNAME- --STEP-- -PSTEP-- CCODE ELAPSED-TIME -CPU-TIME-
09.49.33 JOB22361 GSDMV21I N0075036 CMP 0 00:00:00 0.07S
09.49.33 JOB22361 IEF188I PROBLEM PROGRAM ATTRIBUTES ASSIGNED
09.49.33 JOB22361 IEF450I N0075036 LODPERS - ABEND=S000 U0035 REASON=00000000 187
187 TIME=09.49.33
09.49.33 JOB22361 GSDMV21I N0075036 LODPERS U0035 00:00:00 0.02S
09.49.33 JOB22361 GSDMV21I N0075036 LODPLOB FLUSH 00:00:00 0.00S
09.49.33 JOB22361 IEF404I N0075036 - ENDED - TIME=09.49.33
09.49.33 JOB22361 GSDMV22I -N0075036 ENDED. TOTAL CPU TIME= 0.09S TOTAL ELAPSED TIME= 0.61S
09.49.33 JOB22361 $HASP395 N0075036 ENDED - ABEND=U0035

Function to be executed:

Load File Number 4 (PERSONNEL-BASE )
into database 00012 (ADATST12 )

A D A L O D: Error occurred during execution:

ERROR-166, Wide fields exist, but the
database is not UES enabled.
This file can not be loaded until
the database is UES enabled.

       Investigate the cause of the error.                                      
       Correct it and rerun the job.

A D A L O D Terminated 2025-03-28 09:49:32

12

read the user-friendly manual :slight_smile:

13

You’re right the JES listing I provided only included the ADALOD step, and I now understand that the ADALODP job requires all three steps: ADACMP followed by two ADALOD steps. I’ll revisit the JCL and ensure that it includes the initial compress step (ADACMP) with the appropriate input via DDKARTE DD, and that its outputs (DDAUSBA, DDAUSB1) are correctly passed to the ADALOD steps. I’ll supply the complete JCL shortly. Thanks again for pointing this out.

14

Hello and thanks.
Do you need the full JCL I used for ADALOP job ?
Thanks

15

Have you enabled your database for wide-character use (UES enabling)? This is a separate job from the loading JCL. Use the ADADEF utility with this command:
ADADEF MODIFY UES=YES
Then re-run your ADALODP job. If that still fails, yes, please include the JCL.

16

Hello, thanks for following up.
In the ADADEF job we have :-
//DDCARD DD *
ADARUN PROG=ADADEF,SVC=250,DEVICE=3390,DBID=012
/*
//DDKARTE DD *
ADADEF DEFINE DBNAME=ADATST12,DBIDENT=012
ADADEF ASSOSIZE=100,DATASIZE=200,WORKSIZE=40
ADADEF MAXFILES=120
*
ADADEF FILE=19,CHECKPOINT
ADADEF NAME=‘CHECKPOINT’,MAXISN=5000
ADADEF DSSIZE=100B,NISIZE=3B,UISIZE=3B
/*
And completed successfully earlier.

Your suggestion is that UES=YES is missing.

I think I am going to leave and ignore ADALODP job and I think this is something about compressing the file.

Thanks again for following up.

Regards

17

You got a specific error message on the ADALODP that the input file has wide characters, which requires the database to be UES enabled (“ERROR-166, Wide fields exist, but the
database is not UES enabled. This file can not be loaded until the database is UES enabled”).
Stop the database nucleus, run the ADADEF with this input to the //DDKARTE DD *:

ADADEF MODIFY UES=YES
/*

Restart the database, then rerun the ADALODP job.