DB2 Backup with 3590 autoloader

[leeky]

Hi,

I'm on AIX 4.3.3 system with a 3590 autoloader.My database backup consists of several tapes. Every time I back up the database, when the a tape finishes, db2 will return an end-of-media warning to which I will load in another tape.

Other then using TSM/ADSM , can I use any native db2 commands to automate the loading and unloading of tapes when performing backups?

 

[yarnseeker]

I don't know the AIX system but I'm confused by your post.

Your backing up your data. When you get to the end of 1 tape, you get a message to load another. This is perfectly normal and correct.

I don't understand "db2 will return an end-of-media warning "

To the best of my knowledge DB2 wouldn't or shouldn't return any such message unless you've limited the number of tapes to say 3 and DB2 would need more than 3 to complete the backup. Even then I don't think that DB2 will issue the error, I think that the operating system would.

What error are you getting from DB2? Are you getting something like a 00C90094 type error that you looked up and it said it was a tape issue?

I don't believe that DB2 has any commands for "talking to" tape drives directly. I believe that DB2 leaves that entirely up to the operating system under which it is running.

Have you tried speaking about this issue with your DB2 system programmer or your operating system's system programmer?