Solved

ISERIES 400

Posted on 2010-08-28
4
625 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this article we will discuss all things related to StageFright bug, the most vulnerable bug of android devices.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 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

24 Experts available now in Live!

Get 1:1 Help Now