467,168 Members | 944 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,168 developers. It's quick & easy.

DB2LOAD API

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
  • viewed: 974
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by N.V.Dev | last post: by
3 posts views Thread by nekiv90@hotmail.com | last post: by
reply views Thread by Suresh | last post: by
7 posts views Thread by Vivek | last post: by
2 posts views Thread by Vivek | last post: by
reply views Thread by Vivek | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.