DB2LOAD API

[Suresh]

Hi All

In DB2 load API
for struct db2LoadIn

I am setting following values ...

inputInfoStruct.piUseTablespace = NULL;
inputInfoStruct.iSavecount = 0; /* consistency points as
infrequently as possible */
inputInfoStruct.iRestartcount = 0; /* start at row 1 */
inputInfoStruct.iRowcount = 0; /* load all rows */
inputInfoStruct.iWarningcount = 0; /* don't stop for warnings
*/
inputInfoStruct.iDataBufferSize = 0; /* default data buffer
size */
inputInfoStruct.iSortBufferSize = 0; /* def. warning buffer
size */
inputInfoStruct.iHoldQuiesce = 0; /* don't hold the quiesce
*/
inputInfoStruct.iRestartphase = ' '; /* ignored anyway */
inputInfoStruct.iStatsOpt = SQLU_STATS_NONE; /* don't bother with
them */
inputInfoStruct.iIndexingMode = SQLU_INX_AUTOSELECT;/* let load
choose */ /*
indexing mode */
inputInfoStruct.iCpuParallelism = 0;
inputInfoStruct.iNonrecoverable = SQLU_NON_RECOVERABLE_LOAD;
inputInfoStruct.iAccessLevel = SQLU_ALLOW_NO_ACCESS;
inputInfoStruct.iLockWithForce = SQLU_NO_FORCE;
inputInfoStruct.iCheckPending = SQLU_CHECK_PENDING_CASCADE_DEFERRED;

But whenever i run stored procedure depending on this values....
My tablespace goes in backup pending state... though i am setting
Nonrecoverable=SQLU_NON_RECOVERABLE_LOAD

Can you explain me why this was happening or please tell me necccessary
change..

Suresh