Page 1 of 1
How to avoid backup pending tablespaces
Posted: Fri Nov 06, 2015 8:24 pm
by yimwai
We use connector to load data,
Bulk load write mode and append
When the job runs, the table space will become Backup pending
How to avoid this
Posted: Fri Nov 06, 2015 11:38 pm
by chulett
Which database? I have a guess but I'd rather not.
Re: How to avoid backup pending tablespaces
Posted: Sat Nov 07, 2015 7:09 am
by MT
Hi
More detailed information will get you better answers!
I guess - and I am very sure chulett as well - that you are talking about DB2.
Load in DB2 has several options to ensure consistency in the database while it does not use SQL and standard logging to add the data. You have giut a so called Copy option (also within DataStage) where you can define how DB2 behaves.
I urgently recommend you talk to your DBA!
A quick overview:
- Copy NO will place the tablespace in backup pending - the way out is to do a backup
- Copy Yes will store a copy of the loaded data and will not cause the backup pending state
- nonrecoverable load - which will leave the table nonrecoverable which means in case of a problem after the load and a db restore operation the table has to be dropped! So take care with this option.
Posted: Mon Nov 09, 2015 8:14 am
by sam334
If you are using DB2 connector specifically, when you select Bulk load, there is a an option NON-RECOVERABLE LOAD- make sure its YES. It can solve the problem if proper tablespace is present in the database.