By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

DB2LOAD API

P: n/a
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

May 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.