8.x FP8: concurrent database activation with AWE-Memory cause the instance to crash

Zahni

Win 2003 Enterprise, 14 GB RAM, /3GB and /PAE

DB2_AWE=1,330000,40000

Simple test: wrote two batches:

:10
db2 activate database ga
db2 deactivate database ga
goto 10

and

:10
db2 activate database isyslfi
db2 deactivate database isyslfi
goto 10

If i run both batches concurrently, the instance crash quickly:

2005-02-22-11.26.47.828000+060 E347153H494 LEVEL: Error (OS)
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, oper system services, sqloVLMAttachVLMSegment, probe:90
CALLED : OS, -, unspecified_system_function OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER
Invalid parameter

2005-02-22-11.26.47.828000+060 I347649H476 LEVEL: Severe
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, oper system services, sqloVLMAttachVLMSegment, probe:100
MESSAGE : sqloVLMAttachVLMSegment failed:
DATA #1 : Hexdump, 4 bytes
0x01BD274C : 0600 0083 ....

2005-02-22-11.26.47.828000+060 I348127H456 LEVEL: Severe
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, buffer pool services, sqlbInitBPDForAWE, probe:40
MESSAGE : Attach Failed, rc =
DATA #1 : Hexdump, 4 bytes
0x01BD276C : 0600 0083 ....

2005-02-22-11.26.47.828000+060 I348585H454 LEVEL: Severe
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x00B20148 : 0000 0000 ....

2005-02-22-11.26.47.843000+060 I349041H445 LEVEL: Severe
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x01BD21A8 : 0000 0000 ....

2005-02-22-11.26.47.843000+060 I349488H491 LEVEL: Warning
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01BD2074 : 0000 0000 ....

2005-02-22-11.26.47.890000+060 I349981H468 LEVEL: Severe
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030
MESSAGE : sqloGetMemChunks not explicitly freed.
DATA #1 : Hexdump, 4 bytes
0x01BD1FF8 : 0100 0000 ....

2005-02-22-11.26.47.890000+060 I350451H468 LEVEL: Severe
PID : 2116 TID : 3984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ISYSLFI
APPHDL : 0-23 APPID: *LOCAL.DB2.050222102647
FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030
MESSAGE : sqloGetMemChunks not explicitly freed.
DATA #1 : Hexdump, 4 bytes
0x01BD1FF8 : 0100 0000 ....

Any Idea, except PMR ?

Nov 12 '05 #1

Subscribe Post Reply

1526

Similar topics

Account activation via email

by: R. Rajesh Jeba Anbiah | last post by:

I'm supposed to do the account activation via email. I mean *not* sending the activation link like http://foo.com/foo.php?actcode=foo. But, I would like it to be like...

PHP

Concurrent testing PostgreSQL Vs MySQL

by: Durai | last post by:

Hi All, I tested "concurrent testing" in MySQL. It works fine. But I couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I used the PHP script to update table( one script...

PostgreSQL Database

FP8

by: Fred Nurk | last post by:

What ever happened to FP8?? Has IBM forgotten about it or is just so bad IBM does not want to make it available??

DB2 Database

Will we be able to apply FP8 directly ?

by: Jean-Marc Blaise | last post by:

Dear all, Will we be able to apply FP8 (that comes out end of January) directly without obligation to go thru FP7a or will we have to step thru FP7a ? I wish to know the answer for both 8.1...

DB2 Database

Install problems re DB2 V8 (FP8)

by: Henry Reardon | last post by:

I installed DB2 for Linux, Unix, and Windows on V8.2 (i.e. 8.1.7) on Windows XP on Friday. I had some problems with migration which are still outstanding - see my earlier thread - but I managed to...

DB2 Database

UDB V8 FP8 - Tablespace Filesystem caching enabled for DMS Raw?

by: UDBDBA | last post by:

All: I see that that DMS tablespaces using raw devices have "File System cache" enabled by *default*. My understanding is that file system cache is applicable only for SMS. Here is the...

DB2 Database

How to limit concurrent users/logins

by: mgPA | last post by:

Short: How can I limit the number of concurrent logins to Access (2000) DB? Long: I seem to be having the problem discussed in previous postings of having more than 9 or 10 concurrent logins. ...

Microsoft Access / VBA

Will the code be much different if requirement on the number ofmaximum concurrent visitors is greatly different?

by: tenxian | last post by:

It is said as for code, developing a website that can stand 10,000 concurrent visitors is much different from developing a website that can stand 1,000 concurrent visitors, is it true?

PHP

How to create an "activation code" and store it in sql server 2005 database?

by: Andy B | last post by:

I am making a web application that would randomly create an activation code and put it in a database. The web application would then send it in an email to the user with a link to go to and enter...

Visual Basic .NET

Concurrent Updates - Solutions

by: blyxx86 | last post by:

Good Morning Everyone, I am making a PHP web frontend for a MySQL database. I have finally started to create the UPDATE portions of the website and am wanting some opinions/feedback as to what...

MySQL Database

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware