Topic
  • 7 replies
  • Latest Post - ‏2012-11-16T05:29:29Z by SystemAdmin
SystemAdmin
SystemAdmin
9855 Posts

Pinned topic GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

‏2009-11-06T11:40:56Z |
Hi,

As part of creating Master-Replica we are trying to do "Copying data to the replica" task.
But we are getting exception as
"GLPRDB001E Error code -1 from function:" SQLConnect " idsdb"
when we run the below command.

idsdb2ldif.cmd -o <masterfile.ldif> -s <subtreeDN> -I <instance_name> -k <key seed> -t <key salt>

Environment-Windows XP
Version-TDS 6.1

IDS instance, DB2 server are running.

We even tried running above command by logging as DB2 windows created during TDS installation.
Updated on 2012-11-16T05:29:29Z at 2012-11-16T05:29:29Z by SystemAdmin
  • yn2000
    yn2000
    1112 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2009-11-06T17:24:30Z  
    It sounds that your TDS is running on 'Configuration mode only'. Please double check why is that and troubleshoot them. ibmslapd.log probably provides more info on that.
    Rgds. YN.
  • bmatteso
    bmatteso
    108 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2009-11-06T18:00:52Z  
    Hi,

    First, Windows XP isn't supported for running the Server (only the client is supported on XP).
    Second, it would have been much better to have crypto-sync'd the instances, so you don't have to pass in the -k and -t flags. However, the first point makes the second point moot.

    Regards.
  • SystemAdmin
    SystemAdmin
    9855 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2009-11-09T09:27:24Z  
    • yn2000
    • ‏2009-11-06T17:24:30Z
    It sounds that your TDS is running on 'Configuration mode only'. Please double check why is that and troubleshoot them. ibmslapd.log probably provides more info on that.
    Rgds. YN.
    Hi,

    Server instance is not configuration only mode.
  • SystemAdmin
    SystemAdmin
    9855 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2009-11-09T09:29:00Z  
    • yn2000
    • ‏2009-11-06T17:24:30Z
    It sounds that your TDS is running on 'Configuration mode only'. Please double check why is that and troubleshoot them. ibmslapd.log probably provides more info on that.
    Rgds. YN.
    Hi,

    Server is not running in configuration only mode.

    Thanks,
  • yn2000
    yn2000
    1112 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2009-11-09T17:11:51Z  
    Hi,

    Server is not running in configuration only mode.

    Thanks,
    I missed the line, but caught by bmatteso. You cannot install ITDS server (i.e. DB2 EE) on Windows XP.
    Rgds. YN.
  • SystemAdmin
    SystemAdmin
    9855 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2009-12-02T11:46:59Z  
    Thanks for postings
  • SystemAdmin
    SystemAdmin
    9855 Posts

    Re: GLPRDB001E Error code -1 from function:" SQLConnect " idsdb

    ‏2012-11-16T05:29:29Z  
    Please ensure DB2 configured with LDAP is started..

    Try the following

    1.su - <instance Name>

    <instance Name>@<hostname>:/home/<instance Name> db2start

    SQL1063N DB2START processing was successful.

    then start the LDAP instance