IDS Forum

Re: HPL load problem

Posted By:
Date:

Reset the "hostname" column in the "session" table and
you should be okay.


--- "dan.michael...." <dan.michaelis@verizon.com>
wrote:
>
> Given some experience that I've had with HPL, I'm
> guessing that the problem
> is the imported data. I can't remember exactly
> which table in the onpload
> database contains the hostname column, but that data
> is populated when the
> job is created, and then used in the HPL connection.
> You'll have to go
> through that table manually, and update the hostname
> column, setting it
> equal to the hostname of the server that you're
> trying to run the job on.
> We had this problem as a result of a failover
> cluster; you'll want to make
> sure that you use the "real" hostname for the
> machine that you're on, and
> not the name of the "floating" IP address if you're
> on a cluster.
>
> Let me know if you have further problems, but I
> think this is the source of
> your problem.
>
> Dan Michaelis
> 813.978.6534 (office)
> 813.303.3225 (pager)
> dan.michaelis@verizon.com
>
>
> |---------+---------------------------->
> | | "Pawel Tarach" |
> | | <ptarach@hotmail.|
> | | com> |
> | | Sent by: |
> | | forum.subscriber@|
> | | iiug.org |
> | | |
> | | |
> | | 03/18/2003 07:07 |
> | | PM |
> | | |
> |---------+---------------------------->
>
>
>------------------------------------------------------------------------------------------------------------------------------|
> |
>
> |
> | To: ids@iiug.org
>
> |
> | cc:
>
> |
> | Subject: Re: HPL load problem [758]
>
> |
>
>
>------------------------------------------------------------------------------------------------------------------------------|
>
>
>
>
> Hi
> This is not a problem with GUI.
> IDS tries to connect to dbserver "mis_svr".
> Error -25555 means:
> Server server-name is not listed as a dbserver name
> in sqlhosts. The
> database server name that is mentioned in the
> current command is not listed
>
> in the sqlhosts file. Check the server name for
> accuracy. Check that all
> database servers to be accessed are included in the
> sqlhosts file.
>
>
> >From: "Craig White " <cwhite@edcpub.com>
> >To: ids@iiug.org
> >Subject: HPL load problem [757] Date: Tue, 18 Mar
> 2003 17:52:00 -0500
> (EST)
> >
> >I was having a problem using the GUI tool ipload to
> create the jobs on a
> >machine with no gui display. I then created the
> database through the
> >Informix isql tool. Next I ran a schema that I had
> created from another
> >production machine of onpload. I then unloaded the
> tables from the
> >production machine and loaded the development
> machine tables from these
> >files. It seemed to wok OK but I get an error when
> I run the following
> >load
> >script:
> >
> >INFORMIXDIR=/usr6061/informix7;
> >export INFORMIXDIR;
> >INFORMIXSERVER=clipper_tcp;
> >export INFORMIXSERVER;
> > /usr6061/informix7/bin/onpload -p mis_db -j
> customer -flv
> >
> >I get the following error:
> >
> >Cannot open database 'sysmaster@mis_svr' - SQL
> error -25555, ISAM error 0
> >
> >I am running 7.30.UC5 on AIX4.3.3 . Does this
> error look familiar?
> >
> >Thanks,
> >Craig White
> >VP of IS
> >Educational Development Corp.
> >cwhite@edcpub.com
> >918-622-4522
> >
> >
>
>
>
_________________________________________________________________
> The new MSN 8: smart spam protection and 2 months
> FREE*
> http://join.msn.com/?page=features/junkmail
>
>
>
>
>
>
>
>
>


=====
***************************************************
Abraham Kirubakaran
Enterprise Rent-A-Car
St Louis, MO

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com

Messages In This Thread

• HPL load problem
  Craig White -- Tuesday, 18 March 2003, at 5:52 p.m.
  • Re: HPL load problem
    Pawel Tarach -- Tuesday, 18 March 2003, at 7:07 p.m.
    • Re: HPL load problem
      dan.michaelis@verizon.com -- Thursday, 20 March 2003, at 9:53 a.m.
      • Re: HPL load problem
        Abraham Kirubakaran -- Friday, 21 March 2003, at 12:05 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.