(Scott Hayes) I recently spoke with a customer that was rehosting a mainframe DB2/CICS/COBOL application to pSeries AIX. I did this in the mid-90’s. When you find yourself in the UNIX or Linux world, you need to know how to use the VI editor.

(Premnath Srinivasan and Roopa Ramanathan) The IBM Data Server CLI Driver supports application development for IBM Informix and IBM DB2. It is available for download as part of the Informix Client Software Development Kit (CSDK). This article describes how the CLI Driver supports ODBC application de

(Conor O’Mahony) There is a new eBook that describes six reasons to move from Oracle to IBM. The eBook uses real world case studies to illustrate each of the six reasons. The six reasons are performance, cost savings, usability, scalability, flexibility, and reliability.

(Dave Beulke) As I have talked about in previous weeks, another reason to request additional DBA resources are all the security configuration and settings involved with DB2 10 row and column access security. The setup, configuration and monitoring of these row and column access control settings enco

(Amit Bhattacharya) SQL passthrough is a feature in IBM solidDB Universal Cache that allows the application to access data from both the front-end and back-end databases using a single connection. You can configure this feature as the default, or enable it at runtime for a single transaction or for

(Troy Coleman) In the early years dynamic SQL was never used in a production environment. There were several reasons for this, but the biggest was catalog contention. The locks held in any user’s dynamic ad hoc SQL statement could bring down a new version of a program being moved into production.

(Nipun Tomar) IBM DB2 primarily runs on Unix, Linux IBM I, z/OS, and windows server. It is a relational database management system that comes in a variety of versions, running on devices ranging from handhelds to mainframes.

(Lockwood Lyon) You can use the Copy function of ADRDSSU to move datasets and eliminate logical extents. This may be done independently of Reorg. Then, issue ALTER TABLESPACE commands to set the SECQTY, FREEPAGE, and PCTFREE parameters of all of the Catalog and Directory tablespaces and indexes app

(Simon Evans) Techniques for managing how much memory is used and how to extend the available memory on Windows-based operating systems when there is a requirement to assemble many subject areas together into an Adaptive Warehouse project.

Take these steps to generate SELECT privileges for a given USER on all tables in a SCHEMA