how to get a thread trace on the db2 process

now I know that under solaris, I can attach to a pid using gdband typethread apply all btand then redirect and then gdb_output.txtwill have a nice thread trace for me, is there any way to do this under AIX???I need to do this for the db2 process. ...

why does db2 process grow very big over time?

HiWe notice that the db2 process starts at around 38MB and then grows to almost 600MB after importing a couple thousand rows. This memory size does not deflate later, even after the import activity is long finished.Why would DB2 grow to such a size?We use a mature Java application managing its own p ...

How to kill a db2 process

I am a db2 user. I want to know how to kill a db2 process from command line or through control center.First i want to know what are the process are running in db2 server.where to find that?. I am using db2 v9.1 running in windows.Please brief me on this topic. ...

Internal DB2 process scheduling?

does DB2 have any internal process scheduling? I know I can configure my own tasks to be scheduled by DB2 (or rather the DAS server), but I have not done so (and SELECTing from SYSTOOLS.ADMIN_TASK_LIST reports an "undefined name").The reason I ask, is that I'm having a strange problem with my Expres ...

ps -f shows no db2 process

I installed Db2 fine and am able to login as db2inst1 as well, but like the document say when I give ps -f I see no db2 processes, where do i set my path and whats the next step to get going ?TIA ...

db2 idle process script

I have to create a script which will detect how many db2 process is idle.But I am not able to define its threshold. Means when script need to throw alert that IDLE connection is very much high. Its need to be a percentage of application connected to the system ? or anything else. ( let me clear I wa ...

Performance Issue with db2

I have p550 with 4 Logical CPUs, 10GB Realmem, 3 146GB disks and one LPAR is created with min. 1 and max 4 CPUs.When I do "sar -P ALL 2 10"It shows that User% of one CPU is always 100% and other CPUs are mostly idle.There is not much I/O activity on any disk, not much memory faults or paging.20GB of ...

Db2 8.1 on AIX

Is it possible to have two instances one of db2 7.2 and the other of db2 8.1 on the same AIX machine. The AIX OS version being 5.I tried installing and the install goes through fine but when i try to start the db2 8.1 instance it gives the following errorSQL 1220N The database manager shared memory ...

db2 processes hangs after db2stop

Just wondering if any of you have come accross the same sort of situation before. Yesterday one of our db2 udb instances wouldn't come down after issuing db2stop. Also tried db2_kill and then after tried to kill each db2 process (even with root acces) and after all unsucessfull attemps we tried remo ...

Runstats Process

If i submit runstats shell script what db2 process will indicate runstats is running or not. I need to do ps -ef | grep for what. Please throw your inputs. Thanks your ideas are appreciated. ...

DB2 goes mad using CPU for no particular reason

in January current year we have migrated to DB2 Enterprise Edition v9.5 fixpack 2 on Linux and DB2 was working without any problem at all. Only two times so far on weekends (Saturday or Sunday) there was some extensive CPU usage on DB2. Process db2sysc was going mad and consumed 100% of CPU for hour ...

What is purpose of db2wlmd process?

using DB2 v9.5 fp2 on Linux I used db2top utility to monitor which DB2 process consumes max. cpu time. Utility shows that there is "db2wlmd" application that consumes the most CPU.What is this process for and is there any way I can turn it off? Is this process turned on because of "se ...

DB2 behaving strangely

I have written Java code to load my tables in DB2 with large amount of data. The DB2 is setup on a separate machine. When I run the program, it is taking too long. But, when I logon to the DB2 machine and check how many rows are inserted, the row insertion rate seems to increase by about 10 times.Ca ...

db2iupdt error on AIX "DB2 v8.1.1.120" FP13

I have installed FP13 and when i try to run db2iupdt i get the following error-bash-2.05b# ./db2iupdt db2inst1DBI1250E Applications are still using instancedb2inst1.But there is not db2 process running on the server. Here is the output when i run db2iupdt in debug mode. I have pasted the lines from ...

Processes in DB2 ... db2jds.exe versus db2jd in unix ..

I found and APAR IY97750 talking about problems of security with process DB2JDS that must be fixed with FixPak 15 for DB2 UDB v8.2, Then I know that process DB2JDS.exe is a DB2 Process running in Windows enviroment and his functions is:db2jds.exe The DB2 JDBC applet server service.Then the question ...

what are the tablespace backup related db2 processes ?

When we run tablespace backup utility what are the db2 process names created at OS level? ...

DB2 and SAN storage

Have 2 DB2 servers, they have both attach to SAN storageI am thinking if I am able to setup a active-active, without HADR or HACMPStart up db2 process both DB2 server, they will both attach to the same mount pt in SAN.Setup my L5 load balancer to check on the port on regular basis.Whenever my db fai ...

DB2 Express C : Extremely long delays in JDBC calls

We are facing some big performance problems with DB2 Express C (version 9.5), The case details are : Windows XP machine with Core 2 Duo.J2EE Web Application deployed on Tomcat 5.5 using DB2 Express C (version 9.5). Driver in use is Type 4. Database interactions taking a lot of time (in order of minu ...

Don't know what server process is running?

Somewhat unusually, I don't really have a problem as such, it is justthat I don't understand why my application is working. I think it isrelated to DB2, but I don't really know, so sorry if this is the wrongnewsgroup. The problem is because of a big gap between my PC-centeredknowledge and my total l ...

db2cc - Error / Inconsistent DB?

I'm running into huge problems and since I've nearly no DB2 experience I'm close to surrender.. =(I managed to install DB2 on my Linux-Box in spite of all the rpm-Problems. I managed to get the db2cc-Tool running, by editing the script and removing some (for my system) dump tests (java-related).I mo ...

Sql2048n Rc7

We are on UDB V8.1 on AIX.I had encountered this problem earlier - We did a redirected restore and now I cannot connect to the database.I saw lots of stuff on the net ( as well as the replies to my earlier post on the same topic) -I tried to do a db2stop and start - still the problem persisted.Then ...

Incremental backup to TSM tape

AIX 5.3 64 bit$ db2levelDB21085I Instance "arcproda" uses "32" bits and DB2 code release "SQL08027" with level identifier "03080106".Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and FixPak "14".Produc ...

Check the condition of an instance

How can I check an instance to see whether it's still inwork after the database is running and cannot be stop?Can I simply check the db2 process? ...

Questions about STMM, AGENT_STACK_SZ, and BUFFERPOOL

I am a DB2 beginner using Express-C 9.7 in development.There are three questions in short, and I will really appreciate any help. 1) In db2diag.log, the following error appears continuously. 2009-08-11-15.42.56.140996+000 I48188133G560 LEVEL: ErrorPID : 27816 TID : 1656744848 PROC : db2syscINSTANCE: ...

for db2 7.2 AIX, can I start a process of warehouse manager under the console shell?

for db2 7.2 for AIX, can I start a process of warehouse manager under the console shell?I have defined a simple process in the data warehouse center and I want to start such process from the console shell of the AIX, is it possible to do that? ...

How to get process id (pid) in DB2

In Sybase stored procedure, it could use the @@spid to get the user process id. Is there any equivalent method to get it in DB2 store procedure? ...

nmon process monitoring for db2 on AIX

We are using nmon to monitor our systems. One thing I want to ask you about is the display of the process name. With the ps command, the DB2 processes are displayed with their functional name, e.g. agent, prefetchers, I/O cleaners, etc., please see the example below. But in nmon I can only see db2sy ...

help reg usage of procedure ouput in insert statement during process of oracle to db2

I am migrating our application from oracle8i to db2 v9.1, during this process all our udf oracle functions are now chaged as procedures in db2.As oracle allows function calls in dml statements as following:INSERT INTO TestTable(RECORDID, FIELDID, UnitsID) VALUES ( 307, 12,Masters.getUnitsID('Nos')); ...

DB2 ps -ef process list

Quick question, when I do a "ps -ef | grep DB2" I get somthing simalr to:dbusr 2993 2967 0 Oct 9 ? 0:02 db2logts (DB2xx) 0dbusr 2995 2967 0 Oct 9 ? 21:58 db2loggr (DB2xx) 0What does the 0 mean at the far right side of the process name? Is that the counnection count? Please explain.any docs ...

Process to change DB2 connection password

Can someone please point me to the process to update/change the password used for my DB2 connection for Director ver 6.1 Seems to be way more confusing now than previous versions.... ...

Stopping the DB2 listener process

How does one stop the DB2 listener process on DB2 without using db2stop? ...

How to kill a particular process in DB2. ???

I have a process running on. It is an application process and I tried to use "db2 force that particular process" but the process in still alive . What should I do to kill that process or stop that process ?Moreover, that is a production server with critical data in it. So, I have to be very careful ...

Can i use selects to process 'db2' commands and get a resultset ?

Hi, im working with the microsoft ado.net database framework. Is there a way i can process 'db2' commands like 'list db directory' into a select ? Apparently this is the only way i can interact with the db using this framework, and i need to get the information from 'list db directory' but using a s ...

help reg usage of procedure ouput in insert statement during process of oracle to db2 migration

I am migrating our application from oracle8i to db2 v9.1, during this process all our udf oracle functions are now chaged as procedures in db2.As oracle allows function calls in dml statements as following:INSERT INTO TestTable(RECORDID, FIELDID, UnitsID) VALUES ( 307, 12,Masters.getUnitsID('Nos')); ...

understanding the DB2 startup process

I need your help to understand why I am getting the common "SQL1032N No start database manager command was issued." after the FP4 apply on mi installationI am working with a new DB2 9.1 installation on Linux, everything worked ok. Then I applied the FP4 following the instruction on the readme. After ...

DB2 and Process Server query

We are running WebSphere Process Server (7.0) and using DB2 as the database. Process Server occasionally sends a query to DB2 that DB2 takes 20-30 minutes to execute, chewing up all the CPU for the duration of the query. During the execution of the query, DB2 reads in around 9 million records from t ...

db2 batch process commits

I have a piece of code in shell script that reads from a flat file and updates a row in a table. I am updating 1.1 million records at once. My code is committing after every row. Also the process is running for ever. Is there a way I can commit a bunch of records at a time say 500 and then process t ...

Time required for DB2 backup process

I'm looking for an estimate of time taken by DB2 for Backing up database of various sizes. I'm using DB2V7.2 on Windows 2000.When I took the backup last time, the size of database image was about 25 GB and it took about 45 minutes to complete .Basically, I want to find out whether the graph between ...

process db2 down

I have problems with the processes db2(db2pclnr, db2loggr, db2pfchr, db2dlock which are down every 3 days. We have OLTP environment, with db2/Aix.Somebody knows how I can I do to know how these processes are down.In db2diag.log, I have no db2 error. ...

DB2 timeout on automated process

I have built a Powerbuilder Process which runs every day at 10 am . On the odd occasion the Database drops the connection. Well thats what i think it does.It runs the process and once in a while stops and requests a password.Could it be that it thinks the password is wrong or that the Database conne ...

Could anyone share process to unload from DB2 Z/OS(Mainframe) and load DB2 UDB LUW?

I have a need to copy z/OS data and load into DB2 UDB on Linux and Windows Servers. What are the options that I have to accomplish this requirement. Please be kind enough to describe the steps in detail and if possible sample scripts will be very welcomed.My ...

Could anyone share process to unload from DB2 Z/OS and load UDB?

I have a need to copy z/OS data and load into DB2 UDB on Linux(RHEL) and Windows Servers. What are the options that I have to accomplish this requirement. Please be kind enough to describe the steps in detail and if possible sample scripts will be very welcomed.My thanks and appreciation in advance. ...

Some Minor errors in Installation process of DB2 v9.1 AIX 5.2

I receive the next minor errors when install the DB2 v9.1 of DB2.The machine already have DB2 UDB v8.2 installed and working, the errors returned was:ERROR:Could not load program db2fmcu:Symbol resolution failed for db2fmcu because:Symbol ossVersionCodeToString (number 69) is not exported from depen ...

DB2 timeout on automated process

I have built a Powerbuilder Process which runs every day at 10 am . On the odd occasion the Database drops the connection. Well thats what i think it does.It runs the process and once in a while stops and requests a password.Could it be that it thinks the password is wrong or that the Database conne ...

Db2 cache set up process guide?

Is there any guide /document which describs how to set up SolidDB cache for DB2?I have connecter guide downloaded already. But I was not successful in setting up the same with the help of that guide. Any help is welcome! ...

db2stop force HANG - V97 fp2 - AIX 533 / db2fw

Till we have migrated our DB2 from V8.2 to V97 fp2, we have problem with "db2stop force" which maybe HANG.DB SIZE : 1 teraApplication : WAS - CICS (on AIX) - MQ series our procedure : Stop application in the following order : CICS and MQ and then "db2stop force"."db2stop force" should end after 2 mi ...

DB2 UDB UDF registration process

I got problem in UDFS.If I use DBINFO,FINALCALL(SQLUDF_TRAIL_ARGS_ALL) in udf registration I can't get the DBINFO data.Is any relation between those 2? ...

DB2 Replication Process

all , have a nice dayWe are trying to perform replication from V7.1(OS is AIX 4.3.3.0) to V9.7(OS is AIX 6.1). Pls guide me how to perform this task . i didn't know about replication. i read the info center but am not able to get that information because there is no examples . Pls can any body provi ...

DB2 express-c process_error during installation

I have a problem while installing db2 express-c.I try to install it under windows vista, and encountered the following message twice during the process of installation.'An error occured while trying to start the DB2 instance.The return code is 4 and the SQL message is: PROCESS_ERROR'I was able to in ...

DB2 express-c process_error during installation

I have a problem while installing db2 express-c.I try to install it under windows vista, and encountered the following message twice during the process of installation.'An error occured while trying to start the DB2 instance.The return code is 4 and the SQL message is: PROCESS_ERROR'I was able to in ...