Expert Knowledgebase
DB2 and Database Management with Craig Mullins
How to get DB2 admin certified
(10 FEB 2005)
I'm interested in doing certification in DB2 administration for OS/390.
I would like to master the subject, not just get the certification.
Storing a DB2 plan
(10 FEB 2005)
Where exactly is a DB2 plan stored?
Converting NULL with an ALTER statement
(10 FEB 2005)
In DB2, how do I convert a NOT NULL WITH DEFAULT column to NULL? I don't want to drop the table and recreate. Is this possible with an
ALTER statement?
Should I upgrade now to DB2 V8?
(10 FEB 2005)
The other week, I attended a few SHARE sessions on DB2 V8. Should I upgrade to it now? Is it stable?
Hot DB2 V8 features
(10 FEB 2005)
What new features in DB2 V8 jump out at you? Data Partioned Secondary Indexes (DPSIs)? New SQL commands? Better use of Unicode?
Rolling back DB2 tables
(10 FEB 2005)
I have a an online COBOL-CICS-DB2 program where I receive data through
commarea from a front end Java application. This program is accessed from CICS Transaction Server using the program name -- no trans id --...
Getting data to unload
(10 FEB 2005)
I have a DB2 column defined as varchar(300) that is used to store dates in packed decimal form. The date is stored as an array of 5 bytes each.
If there are 10 dates, then the length of the column is 50 byte...
VSAM vs. DB2
(10 FEB 2005)
What's the difference between VSAM and DB2? And why is there a need for converting VSAM to DB2?
Improving performance on a stored procedure that slowed from enqueues
(10 FEB 2005)
A stored procedure that calls a vendor product is experiencing slow performance due to enqueues on VSAM files used by the vendor product. Increases to BUFND, BUFNI in the WLM jobs for these files had no effect....
Online DB2 Catalog tables
(10 FEB 2005)
I am a newbie in DB2 world. Can I get access to the DB2 Catalog tables online? Can you please take a second and point me in the right direction?
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
