Hello,
We use DB2 8.2.4
I have noticed that on one of our sun solaris machines LOAD command don't
work. EXPORT and IMPORT commands works, but if I execute any LOAD - it never ends.
The same LOAD statements takes on another machines less then second.
On those server we have 3 instances and on every database it looks the same -
it never stops.
After I start LOAD command - in db2diag I've found only
2008-07-08-08.54.04.243706+120 I1252210C427 LEVEL: Warning
PID : 26258 TID : 1 PROC : db2lrid 0
INSTANCE: aut NODE : 000 DB : UNIT2
APPHDL : 0-115 APPID: C0A8010A.J80A.02AD08075549
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 81 bytes
LOADID: 24182.2008-07-08-08.54.03.904228.0 (10;110)
Load CPU parallelism is: 7, 0
2008-07-08-08.54.04.276194+120 I1252638C491 LEVEL: Warning
PID : 26250 TID : 1 PROC : db2lfrm0 0
INSTANCE: aut NODE : 000 DB : UNIT2
APPHDL : 0-115 APPID: C0A8010A.J80A.02AD08075549
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
DATA #1 : String, 135 bytes
LOADID: 24182.2008-07-08-08.54.03.904228.0 (10;110)
Starting LOAD phase at 07/08/2008 08:54:04.259599. Table MYSCHEMA .MYTESTTABLE
Did someone have similar problem?
How to try find a reason?
Thank you
J.Kubica 2 1961
On Jul 8, 12:23*am, "J.Kubica" <j...@k.comwrote:
Hello,
* * * * We use DB2 8.2.4
I have noticed that on one of our sun solaris machines LOAD command don't
work. EXPORT and IMPORT commands works, but if I execute any LOAD - it never ends.
The same LOAD statements takes on another machines less then second.
On those server we have 3 instances and on every database it looks the same -
it never stops.
After I start LOAD command - in db2diag I've found only
2008-07-08-08.54.04.243706+120 I1252210C427 * * * LEVEL: Warning
PID * * : 26258 * * * * * * * *TID *: 1 * * ** * PROC : db2lrid 0
INSTANCE: aut * * * * * * * * *NODE : 000 * * * * DB * : UNIT2
APPHDL *: 0-115 * * * * * * * *APPID: C0A8010A.J80A.02AD08075549
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 81 bytes
LOADID: 24182.2008-07-08-08.54.03.904228.0 (10;110)
Load CPU parallelism is: 7, 0
2008-07-08-08.54.04.276194+120 I1252638C491 * * * LEVEL: Warning
PID * * : 26250 * * * * * * * *TID *: 1 * * ** * PROC : db2lfrm0 0
INSTANCE: aut * * * * * * * * *NODE : 000 * * * * DB * : UNIT2
APPHDL *: 0-115 * * * * * * * *APPID: C0A8010A.J80A.02AD08075549
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
DATA #1 : String, 135 bytes
LOADID: 24182.2008-07-08-08.54.03.904228.0 (10;110)
Starting LOAD phase at 07/08/2008 08:54:04.259599. Table MYSCHEMA * *..MYTESTTABLE
Did someone have similar problem?
How to try find a reason?
Thank you
* * * * J.Kubica
Hello,
you're not saying which version of Solaris you're running. If you're
on Solaris 10, and you're trying to load into a tablespace with
multiple containers, you're most likely hitting this Solaris bug: http://bugs.opensolaris.org/view_bug.do?bug_id=2158883
Its impact on DB2 LOAD is described here: http://www-1.ibm.com/support/docview...en&rss=ct71db2
There is a Solaris patch available to take care of this problem, or
you can specify DISK_PARALLELISM 1 on your load command.
/T
Tomas wrote:
On Jul 8, 12:23 am, "J.Kubica" <j...@k.comwrote:
>Hello,
We use DB2 8.2.4 I have noticed that on one of our sun solaris machines LOAD command don't work. EXPORT and IMPORT commands works, but if I execute any LOAD - it never ends. The same LOAD statements takes on another machines less then second. On those server we have 3 instances and on every database it looks the same - it never stops. After I start LOAD command - in db2diag I've found only
2008-07-08-08.54.04.243706+120 I1252210C427 LEVEL: Warning PID : 26258 TID : 1 PROC : db2lrid 0 INSTANCE: aut NODE : 000 DB : UNIT2 APPHDL : 0-115 APPID: C0A8010A.J80A.02AD08075549 FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0 DATA #1 : String, 81 bytes LOADID: 24182.2008-07-08-08.54.03.904228.0 (10;110) Load CPU parallelism is: 7, 0
2008-07-08-08.54.04.276194+120 I1252638C491 LEVEL: Warning PID : 26250 TID : 1 PROC : db2lfrm0 0 INSTANCE: aut NODE : 000 DB : UNIT2 APPHDL : 0-115 APPID: C0A8010A.J80A.02AD08075549 FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0 DATA #1 : String, 135 bytes LOADID: 24182.2008-07-08-08.54.03.904228.0 (10;110) Starting LOAD phase at 07/08/2008 08:54:04.259599. Table MYSCHEMA .MYTESTTABLE
Did someone have similar problem? How to try find a reason?
Thank you J.Kubica
Hello,
you're not saying which version of Solaris you're running. If you're
on Solaris 10, and you're trying to load into a tablespace with
multiple containers, you're most likely hitting this Solaris bug:
http://bugs.opensolaris.org/view_bug.do?bug_id=2158883
Its impact on DB2 LOAD is described here:
http://www-1.ibm.com/support/docview...en&rss=ct71db2
There is a Solaris patch available to take care of this problem, or
you can specify DISK_PARALLELISM 1 on your load command.
/T
LOAD with DISK_PARALLELISM 1 works. It means it is probably solaris bug you
mentioned. Thank you.
J.Kubica This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jun |
last post by:
I have following script
<script>
var Animal = function(name){
this.name = name;
}
Animal.prototype.eat = function (food)
{
|
by: Henry Chen |
last post by:
In Delphi we could tell by the blue dots on the margin of the editor that a
piece of code was compiled or not and because Delphi optimised the
compilation not to contain source that was never...
|
by: harry |
last post by:
Hi,
During compilation, a C# project in my solution triggers the following
warning:
"warning CS0168: The variable 'ex' is declared but never used"
To trigger this warning, it appears the C#...
|
by: McKirahan |
last post by:
The following is from RISKS-LIST: Risks-Forum Digest Sunday 26 December
2004 Volume 23 : Issue 63 archived at <http://www.risks.org>
Date: Thu, 23 Dec 2004 11:27:50 +0100
From: des@des.no...
|
by: hpy_awad |
last post by:
What should I do to avoid the message :
parameter 'argc' is never used
My program is down :
*--------------------
/* Book name : The prodessional programmers guide to C
File name ...
|
by: cs |
last post by:
I have a windows service that on the start method it launches a BackGround
thread, and I am not certain if this is the issue. My problem is that my
service never seems to finish starting, the...
|
by: Kenn Ghannon |
last post by:
I've got an ASP.NET page with a counter subtraction routine in the
Session_End method in the Global.asax.cs:
protected void Session_End(Object sender, EventArgs e)
{
ulong curUsers;
...
|
by: D. Shane Fowlkes |
last post by:
This is a repost (pasted below). Since my original post, I've double
checked the system clock and set all IIS Session Timeout values to 10
minutes. Still ...the problem occurs. I've also...
|
by: Soren Kuula |
last post by:
Hi,
1) If I have a definition + declaration like
<complexType name="fattype">
<complexContent>
<element name="bar" minOccurs="0" maxOccurs="342"/>
</complexContent>
<attribute...
|
by: xlar54 |
last post by:
I've been going through the newsgroup, picking up best practices and
things not to do, as I think it helps to make a good programmer a very
good one. But rather than fishing, I figure that there...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |