| DB2 Topics (view all ...) | Last Post | Replies |
|
| Search for the XML Superstar | 06 Oct 2008 14:17 GMT | - |
As many of you may already know, IDUG's "Search for the XML Superstar"
got underway last week, posing five challenges to students and
developers who want to show off their knowledge of XML. From a video
challenge to a programming contest, the "Search for the XML Superstar"
|
| Advs & disadvs of Self Tuning Memory Management feature of DB2 v9.5 | 06 Oct 2008 12:38 GMT | - |
We are using DB2 v8.2 and are planning to migrate to DB2 v9.5. The
settings of our servers are as follows:
OS: WIN (4 servers) , AIX(1 server)
RAM: 3GB
|
| Collecting DB2 performance results for my thesis paper | 05 Oct 2008 17:29 GMT | - |
As part of my thesis for my MSc Course with the Open University UK, I
need to collect various performance statics for IBM's DB2 database on
Windows.
To this end I have developed a performance test script (DB2 pl/sql)
|
| Leading Zeros | 04 Oct 2008 21:31 GMT | 4 |
On a z/OS DB2 v8 platform, this refers to formatting a SMALLINT field as
two zoned-decimal (character) numerics, with a leading zero when there
is only one significant digit. I tried several different CAST formats
with no luck.
|
| Strange db2acd error | 04 Oct 2008 19:51 GMT | - |
Env: DB2 v9.5 Linux
I get the following recurrent error on db2diag.log .
2008-10-05-01.06.05.811909-180 I27122735E466 LEVEL: Error
PID : 24424 TID : 1126189408 PROC : db2acd
|
| Just checking | 03 Oct 2008 22:51 GMT | 1 |
I have to move a 40 GB database from one windows server to another.
The db has
logretain = recovery
userexit = off
|
| Dynamic sql statement called in a stored procedure SP | 03 Oct 2008 19:31 GMT | 1 |
We have a stored procedure that dynamically builds a sql statement.
Is there an example of how to get the SP to return the result set of a
dynamically generated sql statement.
here is an oversimplified sql statement - just to prove the point:
|
| db2 table space restore | 03 Oct 2008 19:21 GMT | 4 |
im not a db2 person, please forgive me for asking a simple
question..
i would like to restore a tablespace from a current database to a new
database in the same server how do i accomplish this task. I use tsm
|
| outer join table filtering | 03 Oct 2008 19:07 GMT | 2 |
Is it true that the following query:
SELECT emp.empno, emp.lastname, dept.deptname
FROM emp LEFT OUTER JOIN dept
ON emp.workdept = dept.deptno
|
| Please explain query intervals output | 03 Oct 2008 17:21 GMT | 1 |
I found this query on older thread and i can not uderstand output interval
pairs:
How to find min and max values in date intervals:
--------------------------------------------------
|
| Variables in SQL??? | 02 Oct 2008 21:57 GMT | 4 |
Another of those "What's the DB2 equivalent to this Sybase syntax"
I use local variables in Sybase SQL scripts to hold values for use
later in the script.
For example:
|
| Walking a CLOB | 02 Oct 2008 18:07 GMT | 2 |
Friends:
I'm in the unenviable position of having to retrieve rows based on a
deep-dive into a CLOB, searching for a particular constant.
I've tried different options of predicates and their placement, and
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage