Solved

ISERIES 400

Posted on 2010-08-28
4
626 Views
Last Modified: 2013-12-06
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.
0
Comment
Question by:tkshatriya
  • 2
4 Comments
 
LVL 34

Expert Comment

by:Gary Patterson
ID: 33550387
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
 

Author Comment

by:tkshatriya
ID: 33550417
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
 
LVL 4

Expert Comment

by:LewisPower
ID: 33581063
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
 
LVL 34

Accepted Solution

by:
Gary Patterson earned 300 total points
ID: 33581173
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many people tend to confuse the function of a virus with the one of adware, this misunderstanding of the basic of what each software is and how it operates causes users and organizations to take the wrong security measures that would protect them ag…
Sometimes a user will call me frantically, explaining that something has gone wrong and they have tried everything (read - they have messed it up more and now need someone to clean up) and it still does no good, can I help them?!  Usually the standa…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now