Skip to Content
author's profile photo Former Member
Former Member

loadercli timeout

I'm experimenting sometimes a loadercli timeout during export of a database user

The command issued is

/ict/app/sdb/programs/bin/loadercli -d $DB -u $DB_USER,$DB_PASSWD -E 0 -b $SQL_FILE -cs ';'

Sometimes it works

Other times it gives this output

Loader protocol: '/root/.sdb/loader/log/loader.prt'

User DBA connected to database PSFPROD on local host.

USE USER finecowl finecowl

Successfully executed

SQLMODE ORACLE

Successfully executed

SET MAXERRORCOUNT 999999

Successfully executed

CATALOGEXTRACT USER OUTSTREAM FILE '/ict/app/finecowl/dmp/finecowl.cat'

Successfully executed

TABLEEXTRACT USER DATA OUTSTREAM FILE '/ict/app/finecowl/dmp/finecowl.data' RECORDS

<b>Error during execution

-->-25010

-25009

Failure in db communication (request): 3 = connection broken by TIMEOUT.</b>

Any workaround or hint on this timeout?

The db is running normally and it was always online in the meantime

I run through the options and don't see nothing to modify the timeout

Maxdb is version 7.0.5.39

Loader 7.5.0 Build 044-123-149-413

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 15, 2007 at 03:22 PM

    Hi Stefano,

    the parameter to look for is SESSION_TIMEOUT. The default for this parameter is 900 s.

    Could you please check the knldiag file for entries for the time the problem occurs. The error reported by the Loader points out that actually the kernel stopped communicating with the Loader because of a timeout. Any hints here would be interesting.

    Furthermore I would like to encourage you to use the newest available Loader. The version you use is rather ancient :-). As the Loader is downwards compatible there should be no problems in using a newer version with the Database version you use.

    Best regards,

    Steffen

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.