We have DB2 8.2 installed on Linux Redhat server. What's the easy way to
monitor the linux server to check the database availability? since our first
goal is just want to be notified that everything's up and
Working, alerted when the server is down, or something unexpected happened. ...

We intend create system to store documents in company.
Size of documents: 100k-2M, hundred thousands or milions files.
We are considering the possibility to store documents in DB2 or in
filesystem.

If I have a stored proc which returns (using RETURN, not an OUT
parameter) a value, how can I get it in a CLI application?  Thanks in
advance!

I wrote code that parses the db2diag.log to look for errors that would
require us to generate a message to a service center indicating
something is wrong. My problem is trying to figure out what the errors
are. From studying the log, I noticed the codes on the first line after

We are considering to update from V8.1 Fixpak 8 to Fixpak 9.
Operating System Information:
OSName:   AIX
NodeName: mdxxx01, mdxxx02, mdxxx03, mdxxx04

I want found time when a column was added to table.
Andy

I want to pass the content of a clp-file as a parameter for db2clpex?
E.g.:
db2clpex db2 -z log.txt -tvf "connect to mydb user myuser using
mypassword;select * from table;connect reset", but I don't know how to

Db2 8.1.3 Windows
I have to load a table with an identity column with GENERATED ALWAYS
option.
I have to load the data in the identity column as it is.

I tried revoke all priviledge from user
and REVOKE  DROPIN ON SCHEMA  
Still the creator can drop the table.

Is there any DB2 SQL statement that could generate rows of intermediate
dates by providing the start and end dates??
If 2006-1-1 and 2006-1-31 are provided to the SQL, the output will look
like :

  I am facing the following error when trying to use DB2 import
command under DB2 version 7.2.
SQL3040N  Unable to use the lobpath/lobfile parameters as specified.
Reason code: "1"

2 servers with solaris,veritas cluster and DB2 UDB ESE v8.1 with
fixp10. ON the primary db2 server did I create 2 db2 instances and the
admin instance. It is possible to start both db2 instances and the db2
admin server on the primary server but ...failover works only for the 2

I have written a homegrown monitoring script to capture table snapshots
and dynamic sql statements.  I run this script for a period of about 20
hours a day from Monday to Friday.  It uses work files to store interim
data while formatting the snapshot outputs, and the final output

I have to send a file on 3rd friday of every month. Can you please let
me know how to get the 3rd friday on every month using SQL

[Follwing up on String vs Numeric Type
<URL:http://groups.google.com/group/comp.databases.ibm-db2/browse_frm/thread/77ece2ac
84980feb/3c58dd32c336fdd7?q=17-way&rnum=1#3c58dd32c336fdd7>]