(Willie Favero) APAR Friday has returned by popular demand. And with the resurrection of APAR Friday, we have something for OSC.
Tag: IBM
How many DB2 for z/OS Stored Procedure Applications?
(Julian Stuhler) As always, the answer to this is it depends! However, here are some basic rules of thumb that you may find useful:
DB2 problem determination using db2top utility
(Tao Wang and Shen Li) Get the best possible performance in complex IBM DB2 for Linux and UNIX environments with the db2top utility. In this article, you’ll learn about the advantages this tool offers, and see how to use it for monitoring and troubleshooting. In addition, you can follow two sample c
IBM DB2 Connect allows SQL data sharing
(Kent Milligan) We have two System i machines connected with a 1G pipe. I want to create a SQL view on one of the machines using data from the other machine. How can I accomplish this? (R)
Whats new and exciting in IBM Data Studio Developer 2.1
(Sonali Surange and Zeus Courtois) Discover how IBM Data Studio Developer 2.1 will help you better understand your database application. See how the new implementation of Data Studio Developer can improve your productivity and enable better collaboration between developers and DBAs. Follow along wit
And the number of partitions is?????
(Willie Favero) Some number between 1 and 4,096. It’s also the question I asked on the DB2-L list a few days ago. I was very pleased with the great response I received. However, before building all of these table spaces, I thought I would also ask the “number of partitions” questions here. One can n
Skills Zone: DB2 Certification Answers
(Howard Fosdick) I’m often asked about the DB2 certification process; I’ve pulled together answers to the queries I hear most often. You can find more information about many of these topics in my previous columns (see Resources).
How database views get deleted from AS/400 libraries
(Kent Milligan) In my company we are using V5R4, AS400 machine, DB400 database. I am using the iSeries Navigator (Run SQL Script window) to interact with the database. (R)
Let’s talk about star joins
(Willie Favero) I’m building some test cases for some work I am doing. I thought it might be nice to actually get my data to reflect what customers are using in real life. If you would answer a few questions for me, six to be exact, it would really be helpful.
Virtual Storage Loses Mind Share
(Robert Catterall) Last week, I taught a class on DB2 for z/OS data sharing recovery and restart to a group of people from a large Asia-based financial institution. The students appeared to be relatively young – I’d guess that most were in their 20s or 30s. At one point, I was explaining that a rebu
