Expert Knowledgebase
DB2 and Database Management with Craig Mullins
Rownum code solution for DB2 on the OS/390
(10 FEB 2005)
Craig,
My supervisor and I figured out how to simulate the Oracle rownum feature in DB2, version 7.1 , on the OS/390. Here it is!
SELECT DEPTNO, ROW# FROM DEDBADM.DEPT TB1,
TABLE (SELECT COUNT(*)...
The benefits and drawbacks of DB2 V8
(10 FEB 2005)
What are the benefits/drawbacks to upgrading to DB2 V8?
Who is using the DB2 table?
(10 FEB 2005)
In DB2, is there anyway we can figure out how many people are using the same table?
z/OS DB2 tuning resources
(10 FEB 2005)
I am interested in gaining more knowledge on how to tune DB2 applications on z/OS. Could you please suggest any books that specifically addresses the area of DB2 performance tuning.
Parallel processing against a DB2 table
(10 FEB 2005)
I have a table that stores Order data (master) and its associated data is stored in various other DB2 tables. I have a need to download all this data -- from 15 different tables -- every morning through a COBOL...
The mainframe as a viable data server platform
(10 FEB 2005)
Would mainframe DB2 as a database be a viable architecture for Internet applications?
What would be the pros and cons in terms of technical issues, cost, etc. for having mainframe DB2 as the ultimate databa...
When do we need to reorganize a table? Part I
(21 JUN 2004)
When do we need to reorganize a table? We are currently under version 5 and next
month we are going for version 7.
When do we need to reorganize a table? Part II
(21 JUN 2004)
When do we need to reorganize a table? We are currently under version 5 and next month we are going for version 7.
How can I access tables that were created by another user?
(21 JUN 2004)
How can I access tables that were created by another user?
Question concerning nulls
(21 JUN 2004)
I have a question regarding nulls. I have a table emp(NAME CHAR(20))and I have some rows like this
CRAIG
SHASHI
------------
CANADA
...etc
My second row is having 20 blank bytes.......
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
