FileAid Batch - Search a string in all GDG generations



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

FileAid Batch - Search a string in all GDG generations

Postby agentskywalker » Thu Aug 14, 2014 3:15 pm

Hi,

My requirement is, I need to search for a string in all GDG generations(appx 100). I need the name of the dataset/generation in spool.
The string is at a specific position.
The search should start from (Latest Gen - 1) up to oldest generation present.
Each generation is of almost 15 GB size.

I have a working code using FilaAid which works for some other GDG, relatively small generations(15) and smaller sized generations.
But it starts from the latest gen to oldest one.
Is there a way of skipping the latest gen ???

//FILEAID  EXEC PGM=FILEAID             
//SYSPRINT DD SYSOUT=*                 
//SYSLIST  DD SYSOUT=*                 
//DD01     DD DSN=my.gdg.base,
//            DISP=SHR                 
//SYSIN    DD *                         
$$DD01 LIST OUT=0,                     
            IF=(33,EQ,C'my_string')   
/*                                     
//*                                     


This utility gives GDG generation name in the spool, more like a dump, but it does(for the smaller GDG).
However, it just hangs/does nothing for the bigger GDG.

Any suggestion on getting this work?

Any other tool that can be used for this scenario ? :idea:

Best regards.
If at first you don't succeed; call it version 1.0 !!!
User avatar
agentskywalker
 
Posts: 8
Joined: Thu Mar 13, 2014 10:48 am
Location: Pune, India.
Has thanked: 1 time
Been thanked: 0 time

Re: FileAid Batch - Search a string in all GDG generations

Postby NicC » Fri Aug 15, 2014 2:55 pm

You can either use he gdg base as in your other job and then edit your output to remove any finds on the latest generation or you will have to do it the hard way - code each generation manually. That is based on your current solution but I do not know of alternatives that are viable but maybe someone else has experience of other tools or has a better ability to 'think outside the box'.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: FileAid Batch - Search a string in all GDG generations

Postby Ed Goodman » Fri Aug 15, 2014 9:27 pm

I THINK that either the PRINT or LIST commands will show the dataset in which a string was found.
Ed Goodman
 
Posts: 341
Joined: Thu Feb 24, 2011 12:05 am
Has thanked: 3 times
Been thanked: 17 times

Re: FileAid Batch - Search a string in all GDG generations

Postby agentskywalker » Mon Aug 18, 2014 5:58 pm

Thanks NicC.

I tried the job with some generations of the GDG, and the job ran fine.

As Goodman said, the LIST cmd got me the GDG gen names in SYSLIST in spool.
So, I guess I will be using the hardcoded-way, but use a REXX to do the coding for me. Instead of GDG base, I'll be entering Latest-1 gen to REXX. 8-)

Got a way-around, without solving the original problem. :)
If at first you don't succeed; call it version 1.0 !!!
User avatar
agentskywalker
 
Posts: 8
Joined: Thu Mar 13, 2014 10:48 am
Location: Pune, India.
Has thanked: 1 time
Been thanked: 0 time

Re: FileAid Batch - Search a string in all GDG generations

Postby agentskywalker » Tue Aug 19, 2014 2:49 pm

Thanks a lot NicC.

Here is what was happening.

The JCL, prior to actually start executing(and printing SYSOUT/SYSLIST... in spool), was recalling all the GDG generations. And THAT TOOK TIME.
I was never patient enough to wait for that amount of time and cancelled the job.

Today it took almost 1 hour just to recall all the gens ( as they are pretty big I guess), and then I saw all the read counts in spool.
After the job ran for almost 1.5 hours, it completed and I got my needed results in SYSLIST.

So, although the job is fine, still I have to go with the way-around I got earlier because of the time factor. :P
If at first you don't succeed; call it version 1.0 !!!
User avatar
agentskywalker
 
Posts: 8
Joined: Thu Mar 13, 2014 10:48 am
Location: Pune, India.
Has thanked: 1 time
Been thanked: 0 time


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post