ISERIES 400

We using object ABC which was created. Which is adding/updating rectods in 13 files.  
Change/Usage information:                                    
  Change date/time . . . . . . . . . . :   05/23/09  05:31:14

we dont own the source for ABC.

Two days back the job failed for some reason. One of tech. support rename physical file to abc0825 it had logical file attached and changed back to original file ABC.

now object says file ABC created
 Change/Usage information:                                    
   Change date/time . . . . . . . . . . :   08/27/10  22:43:32
   Usage data collected . . . . . . . . :   YES                

Now the problem is for some reason when job run last night it didnt updated two column in ABC file . I did DSPDBR and i dont see any depedance on the ABC physical file. (where as it has logical file which is pointing towards abc0825).

can someone please help what need to be done ...We need original object for physical and logical file so program run correctly and update the row in those two columns.

Since we dont own the source we can't re-compile the physical and logical file.
tkshatriyaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gary PattersonVP Technology / Senior Consultant Commented:
Renaming a physical file does not change the file's creation date.  Looks like tech support may have RENAMED the PF to abc0825, and then COPIED the renamed file using CPYF or CRTDUPOBJ.  If that is what happened, then the logical files are still attached to abc0825, since copying a file does not cause it's dependent logicals to be copied.

If the tech wanted to save a copy of the current file contents, he should have COPIED the file (CPYF or CRTDUPOBJ) instead of renaming it.  That is the cause of the problem.

1) Does the logical still exist, or was it deleted?  If it was deleted, and you don't have source code, you'll need to restore the logical it from a recent backup (RSTOBJ).  Only restore the logical file.
2) If the LF still exists, what physical is the logical file attached to right now? (Probably the abc0825 file).

DSPFD FILE(lib/logicalfilename) - look under the Access Path Description section to see the Physical referenced.

In this case, the fix is to:

1) RENAME the current ABC file (RNMOBJ) to ABCtemp
2) RENAME the ABC0825 file back to ABC (RNMOBJ)
3) Then MAKE A COPY of ABC (CRTDUPOBJ DATA(*YES)) to ABC0825
4) Then, COPY the contents of ABCtemp to ABC (CPYF)
5) Delete ABCtemp

You should make sure no jobs are using this file as you make these changes.

- Gary Patterson

0
tkshatriyaAuthor Commented:
Thank you Gary for your quick response. Yes, logical is still attached with abc0825.  Tech.support rename the object of physical file abc0825 to ABC and then recompiled the ABC.  now the problem is program object was created (Change date/time . . . . . . . . . . :   05/23/09  05:31:14)  and physical file  compiled yesturday and logical file is still attached with abc0825.

Can i restore the object of the PF and LF file ABC from last week back up. Will my program work ?
0
LewisPowerCommented:
Hi tkshatriya,

Yes, restoring your file and logicals should be a solution (I would suggest you to delete the logical files first and make sure your phisical file is still abc0825 for not interferring). But you might lose datas between de backup file and your current one...

Lewis


0
Gary PattersonVP Technology / Senior Consultant Commented:
No idea if your program will work, I'm afraid.  I'd need to know more about the program and the contents of the file to make a guess.  Restoring may be your only option, though.  

LewisPower gives good advice above.

If the file content is critical, or is related to other data, maybe not.  

If the file is just a work file that is cleared every time the program runs, or contains static data, then you may have no problems.

Why did tech support change the files around in the first place?

- Gary Patterson
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Operating Systems

From novice to tech pro — start learning today.