database takes long time to process Post: 302702477

Sponsored Content

Special Forums UNIX and Linux Applications database takes long time to process Post 302702477 by techy1 on Tuesday 18th of September 2012 11:00:36 AM

09-18-2012

Registered User

database takes long time to process

Hi,

we currently having a issue where when we send jobs to the server for the application lawson, it is taking a very long time to complete. here are the last few lines of the database log.

Code:

 
2012-09-18-10.35.55.707279-240 E244403536A576     LEVEL: Warning
PID     : 950492               TID  : 27243       PROC : db2sysc 0
INSTANCE: <INSTANCE>               NODE : 000         DB   : <INSTANCE>D1
APPHDL  : 0-506                APPID: GA65441A.ED3B.120918135356
AUTHID  : <user>
EDUID   : 27243                EDUNAME: db2agent (<INSTANCE>D1) 0
FUNCTION: DB2 UDB, lock manager, sqlpRefillAgentLRBCache, probe:1000
DATA #1 : <preformatted>
Locklist has synchronously grown into overflow memory to avoid lock escalation.
Previous locklist size: 2464
Current locklist size: 2592
2012-09-18-10.35.56.563842-240 E244404113A563     LEVEL: Warning
PID     : 950492               TID  : 27243       PROC : db2sysc 0
INSTANCE: <INSTANCE>               NODE : 000         DB   : <INSTANCE>D1
APPHDL  : 0-506                APPID: GA65441A.ED3B.120918135356
AUTHID  : <USER>
EDUID   : 27243                EDUNAME: db2agent (<INSTANCE>D1) 0
FUNCTION: DB2 UDB, lock manager, sqlpCheckAndDecreaseLocklistOverflowUsag, probe:80
DATA #1 : <preformatted>
Locklist overflow reduced.
Previous locklist size: 4160   New locklist size: 2336
Pages still in overflow: 0
2012-09-18-10.47.25.221334-240 I244404677A513     LEVEL: Info
PID     : 950492               TID  : 119764      PROC : db2sysc 0
INSTANCE: <INSTANCE>               NODE : 000         DB   : <INSTANCE>D1
APPHDL  : 0-11                 APPID: *LOCAL.DB2.120918060823
AUTHID  : <INSTANCE>
EDUID   : 119764               EDUNAME: db2stmm (<INSTANCE>D1) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
MESSAGE : Altering bufferpool "BPTAB_4K" From: "14608" <automatic> To: "21912"
          <automatic>
2012-09-18-10.53.52.459546-240 E244405191A576     LEVEL: Warning
PID     : 950492               TID  : 27243       PROC : db2sysc 0
INSTANCE: <INSTANCE>               NODE : 000         DB   : <INSTANCE>D1
APPHDL  : 0-506                APPID: GA65441A.ED3B.120918135356
AUTHID  : <USER>
EDUID   : 27243                EDUNAME: db2agent (<INSTANCE>D1) 0
FUNCTION: DB2 UDB, lock manager, sqlpRefillAgentLRBCache, probe:1000
DATA #1 : <preformatted>
Locklist has synchronously grown into overflow memory to avoid lock escalation.
Previous locklist size: 2464
Current locklist size: 2592
2012-09-18-10.53.53.057578-240 E244405768A563     LEVEL: Warning
PID     : 950492               TID  : 27243       PROC : db2sysc 0
INSTANCE: <INSTANCE>               NODE : 000         DB   : <INSTANCE>D1
APPHDL  : 0-506                APPID: GA65441A.ED3B.120918135356
AUTHID  : <USER>
EDUID   : 27243                EDUNAME: db2agent (<INSTANCE>D1) 0
FUNCTION: DB2 UDB, lock manager, sqlpCheckAndDecreaseLocklistOverflowUsag, probe:80
DATA #1 : <preformatted>
Locklist overflow reduced.
Previous locklist size: 4256   New locklist size: 2336
Pages still in overflow: 0

does anything here look odd?

techy1

View Public Profile for techy1

Find all posts by techy1

10 More Discussions You Might Find Interesting

1. Programming

fwrite takes extremely long time

After my previous thread, I think I found out what causes the long delays. I run this program on several Linux computers, and the sometimes (after the file with the arrays becomes big) the fwrite takes between 100 ms to 900 ms. This is very bad for me, as I want a timer to halt each 30 ms.... ...

2. UNIX for Advanced & Expert Users

Interrupt signal Control C takes too long to terminate a process

I have a process to terminate, and when keying Control C/ kill -int , it takes 15 minutes to half an hour to terminate the process. I've tried using kill -2, or keying control c twice, however the process seem to be killed abruptly, without writing into the log file. So the only way in order to...

3. Shell Programming and Scripting

Killing a process that takes too long

Hello, I have a C program that takes anywhere from 5 to 100 arguments and I'd like to run it from a script that makes sure it doesnt take too long to execute. If the C program takes more than 5 seconds to execute, i would like the shell script to kill it and return a short message to the user. ...

4. Shell Programming and Scripting

shell script takes long time to complete

Hi all, I wrote this shell script to validate filed numbers for input file. But it take forever to complete validation on a file. The average speed is like 9mins/MB. Can anyone tell me how to improve the performance of a shell script? Thanks

5. Linux

it takes long time to login on server

Hi, I am trying to login using ssh on Red Hat Linux 5 server, The password appears immediately but after I enter the password it takes about 90 seconds to login completely. Please suggest what changes require? Regards, Manoj

6. UNIX for Dummies Questions & Answers

time how long it takes to load a module

Hello, like the title says, how can i measure the time it takes to load a module in Linux, and how how can i measure the time it takes to load a statically compiled module. /Best Regards Olle ---------- Post updated at 01:13 PM ---------- Previous update was at 11:54 AM ---------- For...

7. UNIX for Dummies Questions & Answers

Changing Password process takes a long time

We are running unix. After a reboot of the server we have found that changing password takes a long time. if type in passwd "username" you can type in the 1st instance of the password , press enter , then it will wait for about 3 minutes before bringing up the confirm password line typing it in...

8. Shell Programming and Scripting

sort takes a long time

Dear experts I have a 200MG text file in this format: text \tab number I try to sort using options -fd and it takes very long! is that normal or I can speed it up in some ways? I dont want to split the file since this one is already splitted. I use this command: sort -fd file >...

9. Shell Programming and Scripting

Wget takes a long time to complete

Hi, I wish to check the return value for wget $url. However, some urls are designed to take 45 minutes or more to return. All i need to check if the URL can be reached or not using wget. How can i get wget to return the value in a few seconds ?

10. Shell Programming and Scripting

Transfer file from a server takes long time

It takes 6 hrs for a 90 GB zip file that i am copying / transferring from serverA onto serverB. scp user1@serverA:/opt/setup/cash.zip . Output: cash.zip 21% 19GB 4.7MB/s 4:11:46 ETA uname -a SunOS serverB 5.11 11.2 sun4v sparc sun4vCan you please suggest if i could do...

LEARN ABOUT CENTOS

tapset::nfs

tapset::nfs(3stap)														tapset::nfs(3stap)

NAME

       tapset::nfs - systemtap nfs tapset

DESCRIPTION

       nfs.fop.llseek
	      NFS client llseek operation

	       See probe::nfs.fop.llseek(3stap)
	       for details.

       nfs.fop.read
	      NFS client read operation

	       See probe::nfs.fop.read(3stap)
	       for details.

       nfs.fop.write
	      NFS client write operation

	       See probe::nfs.fop.write(3stap)
	       for details.

       nfs.fop.aio_read
	      NFS client aio_read file operation

	       See probe::nfs.fop.aio_read(3stap)
	       for details.

       nfs.fop.aio_write
	      NFS client aio_write file operation

	       See probe::nfs.fop.aio_write(3stap)
	       for details.

       nfs.fop.mmap
	      NFS client mmap operation

	       See probe::nfs.fop.mmap(3stap)
	       for details.

       nfs.fop.open
	      NFS client file open operation

	       See probe::nfs.fop.open(3stap)
	       for details.

       nfs.fop.flush
	      NFS client flush file operation

	       See probe::nfs.fop.flush(3stap)
	       for details.

       nfs.fop.release
	      NFS client release page operation

	       See probe::nfs.fop.release(3stap)
	       for details.

       nfs.fop.fsync
	      NFS client fsync operation

	       See probe::nfs.fop.fsync(3stap)
	       for details.

       nfs.fop.lock
	      NFS client file lock operation

	       See probe::nfs.fop.lock(3stap)
	       for details.

       nfs.fop.sendfile
	      NFS client send file operation

	       See probe::nfs.fop.sendfile(3stap)
	       for details.

       nfs.fop.check_flags
	      NFS client checking flag operation

	       See probe::nfs.fop.check_flags(3stap)
	       for details.

       nfs.aop.readpage
	      NFS client synchronously reading a page

	       See probe::nfs.aop.readpage(3stap)
	       for details.

       nfs.aop.readpages
	      NFS client reading multiple pages

	       See probe::nfs.aop.readpages(3stap)
	       for details.

       nfs.aop.set_page_dirty
	      NFS client marking page as dirty

	       See probe::nfs.aop.set_page_dirty(3stap)
	       for details.

       nfs.aop.writepage
	      NFS client writing a mapped page to the NFS server

	       See probe::nfs.aop.writepage(3stap)
	       for details.

       nfs.aop.writepages
	      NFS client writing several dirty pages to the NFS server

	       See probe::nfs.aop.writepages(3stap)
	       for details.

       nfs.aop.write_begin
	      NFS client begin to write data

	       See probe::nfs.aop.write_begin(3stap)
	       for details.

       nfs.aop.write_end
	      NFS client complete writing data

	       See probe::nfs.aop.write_end(3stap)
	       for details.

       nfs.aop.release_page
	      NFS client releasing page

	       See probe::nfs.aop.release_page(3stap)
	       for details.

SEE ALSO

	  probe::nfs.fop.llseek(3stap),      probe::nfs.fop.read(3stap),      probe::nfs.fop.write(3stap),	probe::nfs.fop.aio_read(3stap),
       probe::nfs.fop.aio_write(3stap),      probe::nfs.fop.mmap(3stap),       probe::nfs.fop.open(3stap),	  probe::nfs.fop.flush(3stap),
       probe::nfs.fop.release(3stap),	     probe::nfs.fop.fsync(3stap),      probe::nfs.fop.lock(3stap),	probe::nfs.fop.sendfile(3stap),
       probe::nfs.fop.check_flags(3stap),		 probe::nfs.aop.readpage(3stap),		 probe::nfs.aop.readpages(3stap),
       probe::nfs.aop.set_page_dirty(3stap),		    probe::nfs.aop.writepage(3stap),		  probe::nfs.aop.writepages(3stap),
       probe::nfs.aop.write_begin(3stap),  probe::nfs.aop.write_end(3stap),  probe::nfs.aop.release_page(3stap),  stap(1), stapprobes(3stap)

IBM
									---							tapset::nfs(3stap)