Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012

    Question Unanswered: unable to run db2dsdcfgfill command

    I am using DB2 Enterprise 9.7 FP3 in windows server 2008.
    For exporting a huge dataset, my db2 always returns me with error: ERROR [57014] [IBM][DB2/NT64] SQL0952N Processing was cancelled due to an interrupt.

    I googled this information and get suggestions to set querytimeout=0.
    For that purpose, I have to create and populate the configuration file db2dsdriver.cfg using command db2dsdcfgfill.

    It seems to be an easy task except I cannot make it run! I always get error message: SQL1534N The call to db2dsdcfgfill failed because invalid command options were specified.

    Here is my command:
    db2dsdcfgfill -i DB2 -p C:\DB2 -o C:\ProgramData\IBM\DB2\DB2COPY1\cfg
    Can someone please help me? Many many thanks in advance!!

  2. #2
    Join Date
    Aug 2001
    RTFM carefully!!!

    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

    Clearly says :

    -p instance-path
    The full path of the database manager instance directory under which the system database directory, node directory, and DCS directory are located.
    Cannot be used in combination with -i.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2012
    Thanks a lot!!! That did the trick.

    However, this automatically generated cfg file only contains <dsncollection></dsncollection> but without <databases></database> <parameters></parameters> according to the sample file. Then when I tried to connect to db2, I got [IBM][CLI Driver] CLI0199E Invalid connection string attribute.

    So I manually added the <databases></database><parameters></parameters> by myself as
    <database name="Mydatabase" host="localhost" port="50001">
    <parameter name="DB2ADMIN" value="db2admin"/>
    <parameter name="DB2GSE" value="db2admin"/>
    <parameter name="EXPLORER" value="db2admin"/>
    <parameter name="FIELDBOOK" value="db2admin"/>
    <parameter name="FORUM" value="db2admin"/>
    <parameter name="PROVIDER" value="db2admin"/>
    <parameter name="enableWLB" value="true"/>
    <parameter name="maxTransports" value="50"/>
    <parameter name="enableACR" value="true"/>
    <parameter name="QueryTimeout" value="0 | positive integer"/>
    However, it still does not work. And I cannot find the explanation of the structure anywhere.

    Could you please help me?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts