Avatar of matrix0511
matrix0511
 asked on

Where to Find Table in Backup LIB on AS400?

I executed the following tasks below to copy a table from one LIB (CRPDTA) to a backup LIB (TBLBACKUP).

However, after running this I would now like to verify the records in the table in the backup LIB to make sure everything went ok. But it fails when I try to run the table count.


Here is the tasks I took to backup/copy the table:

Save data in files before generating tables, if there are table generation requests.
- Using OWPKGBLD menu on OSK3, run option 25.
- Enter the following information:
  From file  . . . . . . . . . . . > F551201Z        
    Library  . . . . . . . . . . .     CRPDTA
  To file  . . . . . . . . . . . .      F551201Z
    Library  . . . . . . . . . . .     TBLBACKUP
  From member  . . . . . . . . . .   *FIRST        
  To member or label . . . . . . .   *FIRST        
  Replace or add records . . . . .   *NONE        
  Create file  . . . . . . . . . .   *YES                
  Print format . . . . . . . . . .   *CHAR

It said the copy was successful.

But when I try to check the records by running a record count command I get this:

                              Enter SQL Statements      
                                                         
 Type SQL statement, press Enter.                        
        select count(*) from crpdta/f551201z            
      SELECT statement run complete.                    
    >                                                   
                                                         
         select count(*) from TBLBACKUP/f551201z        
      F551201Z in TBLBACKUP type *FILE not found.        
    >                                                   
                                                         
         select count(*) from tblbackup/f551201z        
      F551201Z in TBLBACKUP type *FILE not found.
Mainframe OSDB2

Avatar of undefined
Last Comment
Member_2_276102

8/22/2022 - Mon
SOLUTION
Gary Patterson, CISSP

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Theo Kouwenhoven

Try WRKOBJ *all/f551201z  
then you get a list of all ibraries where f551201z    is located, maybe you mistyped something
matrix0511

ASKER
Thanks guys. I won't be able to connect back to this client system until later this week. I'll try your suggestions then.

Thanks!
ASKER CERTIFIED SOLUTION
Member_2_276102

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes