Skip to Content
0
Former Member
Aug 06, 2009 at 04:52 PM

loadercli timeout

59 Views

Hello

I'm unable to export data via loadercli from a perfectly running maxdb instance (7.5.0.34)

I'm able to backup the db but i need to export a single user

The only way i know so far is to use loadercli

with the

TABLEEXTRACT USER DATA OUTSTREAM FILE <file> RECORDS

command.

When i launch this the command simply seems to hang, no output file is open, nor written

and the db seems to continue to work correctly

I look into knldiag.err and other db files but i see no errors there.

After a while (ten minutes or so) i get

ERR -25010

-25009

Failure in db communication (request): 3 = connection broken by TIMEOUT.

and the loadercli stops without any data output written.

If i trace the loadercli i see that it is waiting on a semop system call

(maybe is waiting the database to do the extraction operation?)

I remember to have done this in the past without problems and really nothing has changed

as far as i know since this is a stable release running some portals.

Question are:

What could be the cause?

Is possible to extend this timeout?

There is any other way to export data of a single db user?

thanks in advance