Hi,
We have a custom application used by a customer on DB2 8.1.5 AIX 5.1,
we have tested it with 8.1.0 AIX 5.1 and everything works fine. But
with 8.1.5 we get the above error. The other applications connecting
to other instances of the database works fine.
lsattr -E -l sys0 | grep maxuproc gave the output
maxuproc 4096
ps -ef | grep <instance Name> | wc -l
returned 665
Also have checked on the extended shared memory to be used, in fact
the customer is using the TCP/IP, and this works, if the application
connects from a Windows environment. It seems to be a problem from
the AIX configuration.
The server side code of the application is written in C++ and the UI
is Servlet pages powered by IBM WebSphere 5.2. Any inputs on this
will be greatly appreciated.
Thanks and regards, Udaya.
FYI:
the db2 get db config output is
Database Configuration for Database
Database configuration release level = 0x0a00
Database release level = 0x0a00
Database territory = US
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1
Dynamic SQL Query management (DYN_QUERY_MGMT ) = DISABLE
Discovery support for this database (DISCOVER_DB) = ENABLE
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = ANY
Continue upon arithmetic exceptions (DFT_SQLMATHWAR N) = NO
Default refresh age (DFT_REFRESH_AG E) =
99999999999999
Number of frequent values retained (NUM_FREQVALUES ) = 20
Number of quantiles retained (NUM_QUANTILES) = 40
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = NO
Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60
Data Links Write Token Init Expiry Intvl(DL_WT_IEX PINT) = 60
Data Links Number of Copies (DL_NUM_COPIES) = 1
Data Links Time after Drop (days) (DL_TIME_DROP) = 1
Data Links Token in Uppercase (DL_UPPER) = NO
Data Links Token Algorithm (DL_TOKEN) = MAC0
Database heap (4KB) (DBHEAP) = 6400
Size of database shared memory (4KB) (DATABASE_MEMOR Y) = AUTOMATIC
Catalog cache size (4KB) (CATALOGCACHE_S Z) = 288
Log buffer size (4KB) (LOGBUFSZ) = 256
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 38400
Buffer pool size (pages) (BUFFPAGE) = 1000
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
Number of extended storage segments (NUM_ESTORE_SEG S) = 0
Max storage for lock list (4KB) (LOCKLIST) = 250
Max size of appl. group mem set (4KB) (APPGROUP_MEM_S Z) = 40000
Percent of mem for appl. group heap (GROUPHEAP_RATI O) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_S Z) = 2560
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR ) =
(SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 13333
SQL statement heap (4KB) (STMTHEAP) = 16382
Default application heap (4KB) (APPLHEAPSZ) = 5120
Package cache size (4KB) (PCKCACHESZ) =
(MAXAPPLS*8)
Statistics heap size (4KB) (STAT_HEAP_SZ) = 19973
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Percent. of lock lists per application (MAXLOCKS) = 10
Lock timeout (sec) (LOCKTIMEOUT) = 30
Changed pages threshold (CHNGPGS_THRESH ) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS ) = 40
Number of I/O servers (NUM_IOSERVERS) = 70
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_S Z) = 32
Track modified pages (TRACKMOD) = OFF
Default number of containers = 4
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC
Average number of active applications (AVG_APPLS) = 5
Max DB files open per application (MAXFILOP) = 128
Log file size (4KB) (LOGFILSIZ) = 3000
Number of primary log files (LOGPRIMARY) = 10
Number of secondary log files (LOGSECOND) = 20
Changed path to log files (NEWLOGPATH) =
Path to log files =
/adw/tbs06/adwd3/database/dblog0/NODE0000/
Overflow log path (OVERFLOWLOGPAT H) =
Mirror log path (MIRRORLOGPATH) =
First active log file =
Block log on disk full (BLK_LOG_DSK_FU L) = NO
Percent of max active log space by transaction(MAX _LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPA N) = 0
Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF
Auto restart enabled (AUTORESTART) = ON
Index re-creation time (INDEXREC) = SYSTEM
(RESTART)
Default number of loadrec sessions (DFT_LOADREC_SE S) = 1
Number of database backups to retain (NUM_DB_BACKUPS ) = 12
Recovery history retention (days) (REC_HIS_RETENT N) = 366
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) = 5 5491
What happens when you try all of the suggestions, including the AIX specific
ones such as setting EXTSHM, given in the Messages Reference for SQL1224N?
"Udy" <ud***********@ gmail.com> wrote in message
news:cf******** *************** ***@posting.goo gle.com... Hi,
We have a custom application used by a customer on DB2 8.1.5 AIX 5.1, we have tested it with 8.1.0 AIX 5.1 and everything works fine. But with 8.1.5 we get the above error. The other applications connecting to other instances of the database works fine.
lsattr -E -l sys0 | grep maxuproc gave the output maxuproc 4096
ps -ef | grep <instance Name> | wc -l returned 665
Also have checked on the extended shared memory to be used, in fact the customer is using the TCP/IP, and this works, if the application connects from a Windows environment. It seems to be a problem from the AIX configuration.
The server side code of the application is written in C++ and the UI is Servlet pages powered by IBM WebSphere 5.2. Any inputs on this will be greatly appreciated.
Thanks and regards, Udaya.
FYI: the db2 get db config output is
Database Configuration for Database
Database configuration release level = 0x0a00 Database release level = 0x0a00
Database territory = US Database code page = 819 Database code set = ISO8859-1 Database country/region code = 1
Dynamic SQL Query management (DYN_QUERY_MGMT ) = DISABLE
Discovery support for this database (DISCOVER_DB) = ENABLE
Default query optimization class (DFT_QUERYOPT) = 5 Degree of parallelism (DFT_DEGREE) = ANY Continue upon arithmetic exceptions (DFT_SQLMATHWAR N) = NO Default refresh age (DFT_REFRESH_AG E) = 99999999999999 Number of frequent values retained (NUM_FREQVALUES ) = 20 Number of quantiles retained (NUM_QUANTILES) = 40
Backup pending = NO
Database is consistent = NO Rollforward pending = NO Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO User exit for logging status = NO
Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60 Data Links Write Token Init Expiry Intvl(DL_WT_IEX PINT) = 60 Data Links Number of Copies (DL_NUM_COPIES) = 1 Data Links Time after Drop (days) (DL_TIME_DROP) = 1 Data Links Token in Uppercase (DL_UPPER) = NO Data Links Token Algorithm (DL_TOKEN) = MAC0
Database heap (4KB) (DBHEAP) = 6400 Size of database shared memory (4KB) (DATABASE_MEMOR Y) = AUTOMATIC Catalog cache size (4KB) (CATALOGCACHE_S Z) = 288 Log buffer size (4KB) (LOGBUFSZ) = 256 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 38400 Buffer pool size (pages) (BUFFPAGE) = 1000 Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000 Number of extended storage segments (NUM_ESTORE_SEG S) = 0 Max storage for lock list (4KB) (LOCKLIST) = 250
Max size of appl. group mem set (4KB) (APPGROUP_MEM_S Z) = 40000 Percent of mem for appl. group heap (GROUPHEAP_RATI O) = 70 Max appl. control heap size (4KB) (APP_CTL_HEAP_S Z) = 2560
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR ) = (SHEAPTHRES) Sort list heap (4KB) (SORTHEAP) = 13333 SQL statement heap (4KB) (STMTHEAP) = 16382 Default application heap (4KB) (APPLHEAPSZ) = 5120 Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8) Statistics heap size (4KB) (STAT_HEAP_SZ) = 19973
Interval for checking deadlock (ms) (DLCHKTIME) = 10000 Percent. of lock lists per application (MAXLOCKS) = 10 Lock timeout (sec) (LOCKTIMEOUT) = 30
Changed pages threshold (CHNGPGS_THRESH ) = 60 Number of asynchronous page cleaners (NUM_IOCLEANERS ) = 40 Number of I/O servers (NUM_IOSERVERS) = 70 Index sort flag (INDEXSORT) = YES Sequential detect flag (SEQDETECT) = YES Default prefetch size (pages) (DFT_PREFETCH_S Z) = 32
Track modified pages (TRACKMOD) = OFF
Default number of containers = 4 Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC Average number of active applications (AVG_APPLS) = 5 Max DB files open per application (MAXFILOP) = 128
Log file size (4KB) (LOGFILSIZ) = 3000 Number of primary log files (LOGPRIMARY) = 10 Number of secondary log files (LOGSECOND) = 20 Changed path to log files (NEWLOGPATH) = Path to log files = /adw/tbs06/adwd3/database/dblog0/NODE0000/ Overflow log path (OVERFLOWLOGPAT H) = Mirror log path (MIRRORLOGPATH) = First active log file = Block log on disk full (BLK_LOG_DSK_FU L) = NO Percent of max active log space by transaction(MAX _LOG) = 0 Num. of active log files for 1 active UOW(NUM_LOG_SPA N) = 0
Group commit count (MINCOMMIT) = 1 Percent log file reclaimed before soft chckpt (SOFTMAX) = 100 Log retain for recovery enabled (LOGRETAIN) = OFF User exit for logging enabled (USEREXIT) = OFF
Auto restart enabled (AUTORESTART) = ON Index re-creation time (INDEXREC) = SYSTEM (RESTART) Default number of loadrec sessions (DFT_LOADREC_SE S) = 1 Number of database backups to retain (NUM_DB_BACKUPS ) = 12 Recovery history retention (days) (REC_HIS_RETENT N) = 366
TSM management class (TSM_MGMTCLASS) = TSM node name (TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) =
We've tried all the options mentioned for the SQL1224N threads.
Finally one observtation we have come across is that when the
application connects from remote system to the DB2 it works, But when
the application running on the same machine tries to access the DB2
locally, it fails, with the fact that EXTSHM settings are enabled.
Could there be something that I missed?
Can anyone elaborate on these ...
The setting EXTSHM should be used with careful consideration.
Do not use EXTSHM=ON at system level.
Do not use EXTSHM=ON at user level.
Use EXTSHM=ON on process level, for only those who need it.
Documentation reveals that EXTSHM=ON uses more CPU time and therefore
could cause damage to performance. EXTSHM=ON uses shared memory
differently than in the conventional normal case.
What does this mean? and how can I achieve it?
-Thanks you all and regards, Udaya.
"Mark Yudkin" <my************ ***********@nos pam.org> wrote in message news:<ci******* ***@ngspool-d02.news.aol.co m>... What happens when you try all of the suggestions, including the AIX specific ones such as setting EXTSHM, given in the Messages Reference for SQL1224N?
Check this link, I once have that problem and fixed with this http://www-1.ibm.com/support/docview...&cc=us&lang=en ud***********@g mail.com (Udy) wrote in message news:<cf******* *************** ****@posting.go ogle.com>... We've tried all the options mentioned for the SQL1224N threads. Finally one observtation we have come across is that when the application connects from remote system to the DB2 it works, But when the application running on the same machine tries to access the DB2 locally, it fails, with the fact that EXTSHM settings are enabled.
Could there be something that I missed?
Can anyone elaborate on these ...
The setting EXTSHM should be used with careful consideration. Do not use EXTSHM=ON at system level. Do not use EXTSHM=ON at user level. Use EXTSHM=ON on process level, for only those who need it. Documentation reveals that EXTSHM=ON uses more CPU time and therefore could cause damage to performance. EXTSHM=ON uses shared memory differently than in the conventional normal case.
What does this mean? and how can I achieve it?
-Thanks you all and regards, Udaya.
"Mark Yudkin" <my************ ***********@nos pam.org> wrote in message news:<ci******* ***@ngspool-d02.news.aol.co m>... What happens when you try all of the suggestions, including the AIX specific ones such as setting EXTSHM, given in the Messages Reference for SQL1224N?
You can use follow command:
export EXTSHM=ON
db2set DB2ENVLIST=EXTS HM
then restart db2 instance.
$)ATZ 22 Sep 2004 10:57:55 -0700 J1#, ud***********@g mail.com (Udy) P4AK: ri********@hot mail.com (Richard) wrote in message news:<4c******* *************** ****@posting.go ogle.com>... Check this link, I once have that problem and fixed with this http://www-1.ibm.com/support/docview...&cc=us&lang=en
Thank you Ricardo, this solution helped us a lot. Cheers to you. Have a good time. Udy. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: AIM |
last post by:
Error in msvc in building inheritance.obj to build hello.pyd
Hello,
I am trying to build the boost 1.31.0 sample extension hello.cpp.
I can not compile the file inheritance.cpp because the two
files containing some templates: adjacency_list.hpp and mem_fn.hpp can
not compile.
Does anyone have any solutions?
|
by: Marvin Libson |
last post by:
Hi All:
I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I
have created a java UDF and trigger. When I update my database I get
the following error:
SQL1224N A database agent could not be started to service a request,
or was
terminated as a result of a database system shutdown or a force
command.
|
by: ja |
last post by:
Hello,
When I run the following query:
select count(*)
from table111
where pf = 'F' and
pet = 'Y'
I get the following error message:
|
by: deko |
last post by:
I use this convention frequently:
Exit_Here:
Exit Sub
HandleErr:
Select Case Err.Number
Case 3163
Resume Next
Case 3376
Resume Next
|
by: p |
last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also
have Crystal 9 pro on my development machine. The web app runs fine on my
dev machine but am having problems deploying. I created the websetup and
built the MSI, have the bundled version. Copied to webserver and ran
Websetup.msi. Said I had to remove old version, which I did, then reran
WebSetup.msi and keeps giving me this error. "The installer was interrupted...
| |
by: db2udbgirl |
last post by:
Env : DB2 UDB 8.2, AIX 5.3, Ascential Datastage (DS)
DS jobs are used to process the backend DB2 database. Sometimes DS job
fails with the message
APT_CombinedOperatorController,0: Fatal Error: Fatal:
SQL1224N A database agent could not be started to service a request,
or was terminated as a result of a database system shutdown or a force
command. SQLSTATE=55032
Unable to connect to DB2 server 'oipdb'.
|
by: madhouse |
last post by:
We are running DB2 version 8 with Fixpack 7 on a server with O/S Windows 2003 but get the error "SQL1224N a database agent could not be started" within the control center whenever I try to create a database or view some properties. I've seen many websites that explain how to resolve this with AIX, but can't seem to find any solutions for Windows 2003. Has anyone got some pointers on how this can be fixed?
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |