Re: SQL6555N : Autoloader db2split on db2 udb eee v7.2 FP9

#1

Hi,

Could you please post your hardware & software configuration? For
example, 32/64 bits OS or 32/64 bits DB2 are in use. How do you
resubmit the autoloader job, foreground or background?

I have encountered the same problem. It was already reported to IBM
for investigation. Until now, there is no idea what's wrong on both OS
& DB2.

regards,

Steven

"Frédéric KAPP" <frederic_kapp (AT) yahoo (DOT) fr> wrote

Quote:

Hi everybody,

I'm getting an error when i load a partitioning table on 12 nodes.
The LOAD starts successfully on all nodes, but when it wants to
split data on 4 nodes, one of this node hangs with SQL6555N.
But Auloloader go on to process but nothing is done, the process lives
always. We have to force the process to stop.
What is amazing is that when we restart auloader with same parameters the
autoloader
doesn't fail and all is successfull.
We are running on AIX 5L.
Can anyone help me to trap this error or explain me why this error happens
SOMETIMES ?
We do not have concurrent autoloader starting and i have cheched
that Autoloader has enough ports to proceed (i have kept options by
default).
May be it is not enough ?
Has anyone an idea ?

Regards;

FK.

#2

Hi,

We use a 32 bits AIX 5L for a 32 bits DB2.
In background or foreground i succeeded to
resubmit the job without any errors.

I can't succeed to reproduce the same problem
with fewer nodes on another machine.
I thought that it was a problem with ports
used by autoloader. I have tried with fewer range
of ports but this time autoloader fails with sql6555n
and it ends properly.
I have checked hardware configuration (maxuproc, ...) recommended by IBM
but our values for this parameters are quite bigger than those recommended.

Regards,

"Steven" <stevenkwtsang (AT) hotmail (DOT) com> a écrit dans le message de news:
24ab938b.0308142020.251b588d (AT) po...OT) google.com...

Quote:

Hi,

Could you please post your hardware & software configuration? For
example, 32/64 bits OS or 32/64 bits DB2 are in use. How do you
resubmit the autoloader job, foreground or background?

I have encountered the same problem. It was already reported to IBM
for investigation. Until now, there is no idea what's wrong on both OS
& DB2.

regards,

Steven

"Frédéric KAPP" <frederic_kapp (AT) yahoo (DOT) fr> wrote

Hi everybody,

I'm getting an error when i load a partitioning table on 12 nodes.
The LOAD starts successfully on all nodes, but when it wants to
split data on 4 nodes, one of this node hangs with SQL6555N.
But Auloloader go on to process but nothing is done, the process lives
always. We have to force the process to stop.
What is amazing is that when we restart auloader with same parameters
the
autoloader
doesn't fail and all is successfull.
We are running on AIX 5L.
Can anyone help me to trap this error or explain me why this error
happens
SOMETIMES ?
We do not have concurrent autoloader starting and i have cheched
that Autoloader has enough ports to proceed (i have kept options by
default).
May be it is not enough ?
Has anyone an idea ?

Regards;

FK.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL6555N : Autoloader db2split on db2 udb eee v7.2 FP9

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: SQL6555N : Autoloader db2split on db2 udb eee v7.2 FP9 - 08-14-2003 , 11:20 PM

Re: SQL6555N : Autoloader db2split on db2 udb eee v7.2 FP9 - 08-15-2003 , 06:14 AM