Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum

Tip: Looking for answers? Try searching our database.

IBM DB2

Recently updated threads


Thread preview

DB2 Topics (view all ...)Last Post  Replies
Search for the XML Superstar06 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.506 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 paper05 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 Zeros04 Oct 2008 21:31 GMT4
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 error04 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 checking03 Oct 2008 22:51 GMT1
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 SP03 Oct 2008 19:31 GMT1
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 restore03 Oct 2008 19:21 GMT4
  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 filtering03 Oct 2008 19:07 GMT2
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 GMT1
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 GMT4
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 CLOB02 Oct 2008 18:07 GMT2
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




©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.