troubleshooting Question

Where to Find Table in Backup LIB on AS400?

Avatar of matrix0511
matrix0511 asked on
DB2Mainframe OS
4 Comments2 Solutions911 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Member_2_276102

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros