Solved

ISERIES 400

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

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 35

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to create custom bootable image of Centos 7.2 4 126
Tablets in POS (point of sale) environment 5 176
Program tries to re-install when opening 6 77
shortcuts on desktops 14 76
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

839 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