f



Finds Many Applications Idle

Hi All,=20

I work on DB2 9.7, AIX.=20

I have been instructed to check if there is any idle applications more than=
 2 hours force them( I use db2 snapshot application and grep with "idle" to=
 get the list of idle application) . I don't know the reason why an applica=
tions left idle , every day I find minimum 10 which are idle for more than =
2 hours. On confirming with Application team , they say there is no active =
session from their side for this long time.=20

Could anyone help to understand what could be the reason for this as no act=
ive session from Application server side?

Thanks in advance.=20
Shashi
0
Shashi
3/2/2016 4:09:47 AM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

1 Replies
294 Views

Similar Articles

[PageSpeed] 37

On Tuesday, March 1, 2016 at 9:09:52 PM UTC-7, Shashi Shekhar wrote:
> Hi All, 
> 
> Could anyone help to understand what could be the reason for this as no active session from Application server side?
> 

This is very typical when an application server has defined connection pools that are too large.  Please have the application owners look at the app server / application configuration for this.

0
Ian
3/2/2016 5:23:41 PM
Reply:

Similar Artilces:

Convert SAP Oracle Database to IBM DB2 Database??
Hello, I would like to hear from anyone here who has converted their SAP Oracle database to IBM DB2 database? Did you realize greater disk saving via DB2 compression? Did you run the latest version of DB2 rather than allow SAP to keep your Oracle version back-leveled? Please, DB2 Bashers need not apply, looking for the business case anyone used to convert to DB2. Thank you. Charles On 6 Feb, 01:52, "Charles Davis" <cdavis10...@comcast.net> wrote: > Hello, > > I would like to hear from anyone here who has converted their SAP Oracle > database to IBM DB2 d...

Connect to IBM DB2 database without installing the DB2 client.
Hi, To connect to the DB2 Driver, from a remote machine. Do we requier DB2 client. Can't we connect by just having IBM DB2 driver which is just a single file (db2cli.dll). I am using vb application from Windows platform to connect to DB2 on Linux machine. Regards, Santosh SB wrote: > Hi, > > To connect to the DB2 Driver, from a remote machine. Do we requier DB2 > client. > Can't we connect by just having IBM DB2 driver which is just a single > file (db2cli.dll). > I am using vb application from Windows platform to connect to DB2 on >...

java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
Hi, I want to get connection to a DB2 database using the driver COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in the classpath. However I am getting the exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Conn.main(Conn.java:44) The code that I am using (with try/catch removed) is as follows: String url = "jdbc:db2:sample"; String driver = "COM.ibm.db2.jdbc.DB2XADataSource"; String dbuser = "db2u...

oct 24 DB2 for LUW Tech Talk: What's Hot from IOD for PureData Systems, IBM Mobile Database and DB2 for LUW
Now we can tell you more! IBM announced PureData Systems on October 9th --= a series of expert integrated solutions for your transactional and analyti= c workloads.=20 In the next DB2 Tech Talk, we'll come to you from Las Vegas with hot news f= rom the conference from a DB2 for LUW, PureData Systems perspective! We'll= also cover a new free software download called IBM Mobile Database, which = helps you enable your DB2 data apps for Android mobile users. And then we = will bring you the best of the presentations from the conference, including= an IBM Champion and other ...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

Finding DB2 instances and databases
Hello Everyone I'd like to create a script/program that can locate all servers running DB2, finding out which instances are running/created and what databases are running under them but have been told but IBM support that this isn't currently possible for a client to do. I'd like to get a second opinion since the CCA seems to be able to manage it without any problems so the API must be there to do it. The main reason why I'd like this is to ensure that our documentation is correct. We have a fair number of servers, DB2 instances and databases out there and we als...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IDLE is disconnecting Application from SQL-Database
I do have got a strange SQL-Connect error since I was including a trigger-procedure using the IDLE command. The armed IDLE ist disconneting the SQL-Database from my Application when it starts running - and when a same time a process / open a browse or any other DB-Connection is beeing made. When the IDLE-Statement is beeing disabled - the application is running without the error. I was able to do a workaround when a Process/Report is running - I am using a Flag while process/report is active. But this can not be a solution for Browse/Update Procedures. Is there anybody who is having the same ...

Deploying the .Net Application with DB2 DataBase
Hi All, i am working on c# application with db2 udb8.2 database.i want to deploy the application on production server with database using msi. I have a scenario where in I need to create the DB2 database using the DB script. How do I go about it? Please suggest. I am wondering if there is any way to create it as we do in SQL server using the Master DB and then executing the scripts. Any suggestions would be appreciated Thanks in advance Regards Srinivas ...

IBM Sets DB2 Database Free
http://www.linuxtoday.com/it_management/2006013101526NWSV Will UniVerse and UniData follow? Henrry Keultjes hbkeultjesat earthlinkdotnet csigline@hotmail.com wrote: > http://www.linuxtoday.com/it_management/2006013101526NWSV > > Will UniVerse and UniData follow? Good catch, Henry (or is it two r's now-see below). We will have to ask IBM what their intentions are with U2 in light of this, but I suspect that the PE editions will be the extent of the free offering. We shall see. Cheers! --dawn > Henrry Keultjes > hbkeultjesat > earthlinkdotnet Hard to compete when others such as MS SQL and Oracle are offering free versions too. mpizl@yahoo.com wrote: > Hard to compete when others such as MS SQL and Oracle are offering free > versions too. The only one my primary ISP will provide for me is MySQL. I suspect that is true of other ISPs as well. I feel the barometer falling in the database industry. cheers! --dawn do you think we can at least get some stuff for free like pdp.net? What is RD going to do to survive? Cant see too many new people wanting to learn or buy pick. dawn wrote: > mpizl@yahoo.com wrote: > >>Hard to compete when others such as MS SQL and Oracle are offering free >>versions too. > > > The only one my primary ISP will provide for me is MySQL. I suspect > that is true of other ISPs as well. I feel the barometer falling in > the datab...

DBI:ibm_db connection for IBM DB2 database
Hello, I am attempting to make a DBI connection from Ruby code running on Win32 (XP) machine to an IBM DB2 v9.5 database running under Linux On the Win32 machine, I have Ruby 1.8.6 (installed with the one-click installer) and have successfully launched the following gem installation commands for the IBM DB drivers and required libraries: >gem install activesupport -v 1.4.2 >gem install activerecord -v 1.15.3 >gem install ibm_db -v 0.8.5 I have also (as required by the IBM documentation at http://rubyforge.org/docman/view.php/2361/967/IBM_DB-0.6.0.pdf) added ‘ibm_db’ to the list of connection adapters on line77 of gems\1.8\gems\activerecord-1.15.3\lib\active_record.rb : RAILS_CONNECTION_ADAPTERS = %w( mysql postgresql sqlite firebird sqlserver db2 oracle sybase openbase frontbase ibm_db ) Here is the ruby code : ------------- require 'rubygems' gem 'ibm_db' require 'dbi' # Connect to a database dbh = DBI.connect('DBI:ibm_db:host=localhost;port=50000;database=MY_DB;', 'username', 'password') # Select some data sth = dbh.prepare('select * from my_table') sth.execute # Print out selected data while row=sth.fetch do p row end --------------- Error reported is as follows : C:\dev\ruby\dbtest>dbtest.rb c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in `load_driver': Unable to load drive r 'ibm_db' (DBI::InterfaceError) from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in `_get_full_drive...

IBM DB2 Database Specialist
We are looking to fill the following permanent position with one of our reputed clients in Saudi Arabia (WESTERNERS ARE PREFFERED). Apply to: APPLICATION@GOAHEADCONSULTING.CO.UK Job Title IBM DB2 Database Specialist Location: Saudi Arabia Objective Responsible for the administration of DB2 subsystems and associated software on the client=92s mainframes Accountable to Data Centre Manager Responsibilities This SENIOR position involves the full spectrum of DB2 system programming activities, including product installation, customization, deployment, software tools integration, ex...

Using .NET to access to a IBM DB2 database
Hello I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I cannot choose the provider, this is the only one I can use. The tables in AS/400 don't have journal and I cannot change this. When I define an ODBC and link tables in ACCESS I can perform every actions. I change the ODBC options to commit data immediately. Using the same ODBC and the same insert statement, when I connect in my C# application using ODBCConnection, I get this error: ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2 UDB]SQL0206 - Column N not in specified tables. Wh...

How to find all DB2 databases available my server LAN?
How to find all DB2 databases available on a my server LAN? Is there a way to find out all the databases that have been created on a DB2 server? all in VB classic 6.0 Thanks. My lan is NT my pc win2000 prof intslled vb classic 6.0 ...

many-to-many volunteers database
So I'm setting up a database that will track shows for a theatre and the volunteers that work each show. My events table looks something like: eventsID eventName eventDate .... my volunteer table looks like volunteerID volunteerFirstName volunteerLastName .... my events_volunteers table looks like: eventID volunteerID position okay... but now I'm having trouble assigning volunteers to the shows to created a new events_volunteers entry. I've tried everything that my filemaker book shows, all throughout this list and even experimented more, but I can't seem to find an acce...

Find the latest updates in database management of IBM
Find the latest updates on IBM database mangement and other topics related to IT such as software testing, Decoding, Flowchart prepartaion and many more... http://www.sqlserversoftware.blogspot.com ...

Re: IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit,
vvcd said: > IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 > bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite > Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express > Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM > Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other > IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 > CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM > Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for Web...

Find the latest updates in database management and many more
Find the latest updates in SQL server 2008 tools and techniques. Get details on database management, software testing, flowchart preparation and many more http://www.sqlserversoftware.blogspot.com ...

Web resources about - Finds Many Applications Idle - comp.databases.ibm-db2

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

NZ doctor Alan Kenny flooded with 'trash' applications for $370k job
The New Zealand GP who couldn't find a doctor to take up a $NZ400,000 ($370,000) position at his practice has been inundated with "trash" applicants ...

NZ doctor Alan Kenny flooded with 'trash' applications for $370k job
The New Zealand GP who couldn't find a doctor to take up a $NZ400,000 ($370,000) position at his practice has been inundated with &quot;trash&quot; ...

Western Digital Introduces Its First Helium-Filled HDDs for Consumer Applications
... two models with 10 TB capacity. This week Western Digital unveiled the world’s first family of helium-filled HDDs designed for consumer applications, ...

NASA just smashed its record for astronaut applications—18,000+
... excitement about the future of NASA, with the space shuttle soon to debut, was palpable. So when the space agency called for astronaut applications, ...

Oklahoma: Concealed Carry Permit Applications Surge Following Obama’s Gun Control
... State Bureau of Investigation numbers suggest gun control talk and Pres. Obama's gun controls contributed to surging concealed carry applications. ...

MBA: Mortgage Applications Decreased in Latest Weekly Survey, Purchase Applications up 27% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 4.3 percent from one week earlier, ...

Mortgage applications down 4.3%
A very slight inch higher in interest rates caused a more than slight drop in mortgage application volume.

European Central Bank Exploring Blockchain Tech Applications
In a new report, the European Central Bank (ECB) has said it is investigating blockchain use within its securities and payments settlement systems. ...

Announcing Blockstack: Decentralized DNS and Identity for Blockchain Applications
The blockchain holds great promise for developing decentralized protocols and applications such as marketplaces (e.g., openbazaar ), registries ...

Resources last updated: 3/2/2016 4:13:26 AM