Feeds:
Posts
Comments

Archive for the ‘DB2’ Category

DB2 for z/OS SQL Query Tuning

Posted in DB2, tagged , , , , on May 2, 2008 | Leave a Comment »

Let’s begin with a brief review of the key points from my previous article. Intuitive tuning is driven by the simple concept that, when a query takes more CPU or elapsed time than expected, it’s typically doing more I/O. The focus of query tuning is to minimize I/O by exploiting the DB2* optimizer, which is [...]

Read Full Post »

Interesting DB2 Concepts presentations

Posted in DB2, tagged , , , , , , , , , , , , , , , on April 18, 2008 | Leave a Comment »

Here you go for the DB2 Presentations for its variety of features..
 
DB2 9 for z/OS RRF Overview & Not Logged Table Spaces
DB2 9 for z/OS Multi-Row Static Insert & Fetch – Coding it in COBOL
DB2 9 for z/OS Scalability
DB2 9 for z/OS Data Sharing
DB2 9 for z/OS Availability
DB2 9 for z/OS Detailed RRF & Reading [...]

Read Full Post »

PDF Document in DB2 Table

Posted in DB2, tagged , on April 14, 2008 | 1 Comment »

Any idea how to store pdf documents in DB2 tables. This needs to be done thru cobol programs?

Read Full Post »

A typical DB2 Query

Posted in DB2, tagged , , , , on April 8, 2008 | 1 Comment »

Sample Records
——————————————————————–
Row 1: 73237155+73240240+73243230+73249335
Row 2: 73237155+73240240+73246345
Row 3: 73237155+73240240+73246345+73249335
………………………………………………………….
Need to sum every 2 digits prior ‘+’ sign plus last 2 digits:
For row 1:  55 + 40 + 30 + 35
For row 2:  55 + 40 + 45
For row 3:  55 + 40 + 45 + 35    
Solution 1: CREATE FUNCTION elements ( string varchar(100) )
  [...]

Read Full Post »

DB2 Table Status – Reason Code

Posted in DB2, tagged , , , , , , , , , on April 1, 2008 | Leave a Comment »

1        The table is in the Set Integrity Pending No Access state. The integrity of the table is not enforced and the content of the table may be invalid. An operation on a parent table or an underlying table that is not in the Set Integrity Pending No Access state may also receive this error if [...]

Read Full Post »

Db2 Version Conversion

Posted in DB2, DB2 Version Upgrade, Mainframe Q&A, tagged , , , , , on March 27, 2008 | Leave a Comment »

Question:
I would know if moving from DB2 7 to DB2 8 changes the way SMF records are
created when running DB2 / CICS|BATCH|TSO commands.
Answer:
Yes, it is possible that you will notice SMF 101 data volume / content
changes, if you implement the new DB2 V8 option ACCUMACC.  IBM did not
add a “number of times package allocated” count [...]

Read Full Post »

Google Search Tool for Db2 queries

Posted in DB2, tagged , , , on March 24, 2008 | Leave a Comment »

Did you ever get bored of crowded results while surfing the internet for Db2 related queries?
IDUG has unveiled an option to have a useful search tool to their DB2 Resources section. Does it seem much interesting?
IDUG is the International DB2 Users Group and it has thousands of members from all over the world. IDUG functions [...]

Read Full Post »