| Thread | Last Post | Replies |
|
| Max Connections | 06 Mar 2006 08:17 GMT | 3 |
Hi Gurus
I came across a small doubt.
Suppose I have Max Connections parameter set to 200.
There are now 200 connections to the database.
|
| Comments in Selects DB2 v8,1.9 UDB Lunix | 06 Mar 2006 08:09 GMT | 1 |
I have some longish (100-150 lines) select statements going from php to
db2. I would like to add some comments to make the sql more
understandable. I want to know if I can do this, and if so, what the
syntax for such embedded comments is: //, --, /*...*/, others?
|
| DB2 8.2 32bit to 64 bit conversion | 03 Mar 2006 22:44 GMT | 2 |
After we upgraded a db2 database on AIX 5.2 from 32bit to 64bit, we
noticed a strange problem. That is, some queries would perform table
scan instead of index scan. However, once the database is downgrade
from 64bit to 32bit, then these same queries would perform index scan.
|
| More than one CURRENT TIMESTAMP in a PROCEDURE | 03 Mar 2006 20:18 GMT | 16 |
I have a PROCEDURE that test other PROCEDUREs.
Timings_Call
------------------
Id
|
| DB2/COBOL Store Procedure Parmeter List (Reply) | 03 Mar 2006 19:08 GMT | 3 |
If you passed all of the fields as one group level when you rejester the SP
you would only be able to use one CHAR field. Now here is the rub. If you
are passing mix data, why not send it in the smallest network transaction
possible. Also why not have DB2 validate each parameter. ...
|
| Urgett !! redirected restore of a tablespace | 03 Mar 2006 18:54 GMT | 1 |
How can we restore a tablespace from a Full backup to a new tablespace
with out effecting the existing tablespace.. (can we use the redirect
option in the backup command for tablespace recovery ???)
Thanks,
|
| CLP Execution | 03 Mar 2006 18:46 GMT | 6 |
How do I cancel a query ( load ) mid way ?
|
| Max Connections | 03 Mar 2006 18:36 GMT | 2 |
Hi Gurus
I came across a small doubt.
Suppose I have Max Connections parameter set to 200.
There are now 200 connections to the database.
|
| Packages, Bind, Prepare and Execute | 03 Mar 2006 16:51 GMT | 1 |
I have started using DB2 UDB ESE v8.2 in Linux recently. I have
seen a lot of articles on packages, prepare statement, bind and execute
statement.
I havent got a clear idea.
|
| How to kill idle connections or sessions | 03 Mar 2006 15:48 GMT | 1 |
I came across a small doubt.
Suppose I have Max Connections parameter set to 200.
There are now 200 connections to the database.
Out of these 200 connections 50 are idle.
|
| How to get my current connection id in SQL | 03 Mar 2006 14:21 GMT | 5 |
i need to access some connection unique identifier from SQL.
In "Control Center" i stumbled into "Application" where i connection id's of
the form:
GA00000B.FC12.00BAC2202852
|
| Bug (?) in SQL: Global temporary table gets truncated on failed insert. | 03 Mar 2006 12:10 GMT | 5 |
During some experimentation with DB2 decimal numbers representations, I
have discovered very unexpected behaviour of the global temporary
table. Consider this example.
Such I had executed the example: # db2 -td@ -f FILENAME.
|
| SQL30081N after RESET DATABASE CONFIGURATION | 03 Mar 2006 07:22 GMT | 7 |
Hi NG,
I wanted to reset the database (manager) configuration with
RESET DATABASE CONFIGURATION
and
|
| Running a batch of sql queries? | 02 Mar 2006 19:13 GMT | 7 |
Our application currently interfaces to SQL Server and Oracle, we're
implementing it into DB2 currently and I have a question to ask.
First a little background - We're interfacing into DB2 v8 on zOS (I
hope the terminology is right - ours is a Windows client app, and the
|
| db2 and the strip function | 02 Mar 2006 19:04 GMT | 2 |
we are currently porting some sql programs from vm/vse to aix. On The
VSE Machine (DB2) the following is valid :
-lots of crap - but in the where clause of the statement :
WHERE
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread