If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL Statement

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-15-09, 07:30
ratheeshknair ratheeshknair is offline
Registered User
 
Join Date: Jan 2009
Posts: 153
SQL Statement

Hi Expert,

1)How to find the query run in a process?
2)Database in our server disconnects frequently .How to find out the issue?

When i checked the DB2Diag i found this
FUNCTION: DB2 UDB, oper system services, sqlofindf, probe:100
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
CALLED : OS, -, unspecified_system_function
OSERR : 2 "The system cannot find the file specified."
DATA #1 : File name, 37 bytes
D:\DB2\NODE0000\SQL00005\0002000f.OLR

is this a matter of concern?

TIA
Reply With Quote
  #2 (permalink)  
Old 09-23-09, 00:19
db2dummy1 db2dummy1 is offline
Registered User
 
Join Date: Feb 2009
Posts: 114
how is taxi business in mumbai lately?
Reply With Quote
  #3 (permalink)  
Old 09-23-09, 01:39
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
Quote:
Originally Posted by db2dummy1
how is taxi business in mumbai lately?
Oh ... you are so badly hit by recession over your part of world.... get your visa stamped.... Cab drivers with DB2 expertise are making huge money in Mumbai
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #4 (permalink)  
Old 09-23-09, 02:00
db2dummy1 db2dummy1 is offline
Registered User
 
Join Date: Feb 2009
Posts: 114
my point precisely!! thank you for the confirmation
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On