db2 luw - File loading issues in DB2 using Load utility -


i have .csv file, comma-delimited (located @ c:/). using db2 load utility load data present in csv file in db2 table. 

load client c:\users\somepath\filename.csv of del    modified nochardel coldel, insert schemaname.table_name;

csv file has 25 rows. after utility completed got error message nochardel. table has 25 rows loaded. when try execute insert/update/delete statement on of tables present in schema getting following error.

lookup error - db2 database error: error [55039] [ibm][db2/aix64] sql0290n table space access not allowed.

could please me whether making mistake or missing parameter causing lock on table.

earlier while loading file similar situation occurred, dba confirmed table space in question in “load in progress” state

changes generated db2 load utility not logged (one of side-effects of high performance). if database crashes after load impossible recover table loaded replaying log records, because there no such records. reason tablespace containing loaded table automatically placed in backup pending mode, forcing take backup of tablespace or entire database ensure recoverable.

there options can specify load command can avoid situation in future:

  • nonrecoverable -- option not place tablespace backup pending mode, but, name implies, table you're loading becomes non-recoverable in case of crash, , option in situation drop , re-create table.

  • copy yes -- option creates copy of table prior loading, can used recover table pre-load state in case of crash.

if loading 25 records, suggest use import utility instead -- not have these restrictions because logged (at price of lower performance, 25 records won't matter).


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more