IBM DB2 10 for z/OS manuals fixed to work with tablet/phone PDF readers like Aldiko

Aldiko Book Reader Premium Full v2.2.3.apkMany PDF readers for smart phones (Android/iphone) and tablets manage the pdf files Calibre_Logobased solely on the Title and Author fields in the PDF file. While for this is fine for your average book, it is not all that helpful with manuals that tend to have abbreviated or no data in the title/author fields. In the case of the manuals for IBM DB2 v10 for z/OS, I’m unable to load the manuals for say v9.7 as they have the same Title/Author data.  I used the same method from SAP Sybase IQ 15.4 manuals fixed to work with tablet/phone PDF readers like Aldiko

Here are the IBM DB2 v10 for z/OS manuals that I’ve ‘fixed’ to work with Aldiko. They are identical to the PDFs on IBM’s website with the exception of the PDF fields I mentioned previously.

NO COPYRIGHT INFRINGEMENT IS INTENDED. IBM, PLEASE FEEL FREE TO TAKE THESE AND HOST THEM.

IBM DB2 v10 for z/OS – Command Reference

IBM DB2 v10 for z/OS – Data Sharing Planning and Administration

IBM DB2 v10 for z/OS – DB2 SQL Reference for Cross-Platform Development Version 4.0

IBM DB2 v10 for z/OS – Installation and Migration Guide – IBM

IBM DB2 v10 for z/OS – Internationalization Guide

IBM DB2 v10 for z/OS – Introduction to DB2 for z/OS

IBM DB2 v10 for z/OS – Installation, Administration, and Reference

IBM DB2 v10 for z/OS – IRLM Messages and Codes

IBM DB2 v10 for z/OS – Licensed Program Specifications

IBM DB2 v10 for z/OS – Managing Performance

IBM DB2 v10 for z/OS – Managing Security

IBM DB2 v10 for z/OS – Messages

IBM DB2 v10 for z/OS – ODBC Guide and Reference

IBM DB2 v10 for z/OS – pureXML Guide

IBM DB2 v10 for z/OS – RACF Access Control Module Guide

IBM DB2 v10 for z/OS – SQL Reference

IBM DB2 v10 for z/OS – User’s Guide and Reference

IBM DB2 v10 for z/OS – Utility Guide and Reference

IBM DB2 v10 for z/OS – What’s New?

IBM DB2 v10 for z/OS – Administration Guide

IBM DB2 v10 for z/OS – Application Programming and SQL Guide

IBM DB2 v10 for z/OS – Application Programming Guide and Reference for Java

IBM DB2 v10 for z/OS – Codes

Share Button

IBM DB2 LUW: What are my database configuration parameters?

IBM’s DB2 (Linux, Unix, Windows) is an db2logoodd beast. Well, if you’re used to any other DBMS on the planet, DB2 is odd and weird. But then, if you’re used to DB2 LUW, then the rest of the planet is smoking stuff. 😉

DB2’s configuration largely comes in two chunks: database manager configuration and database configuration. It might be easiest to think of the database manager as the parent entity that handles connections and the like (e.g. Oracle listener) and the database configuration as the instance configuration. There is a bit more to it than that but let’s focus shall we? Damn it all the helm! I left the Girl Scout cookies on the fridge at home where the kids couldn’t see them!

To pull the database manager configuration, connect to your DB2:

$ db2
db2 => connect to GOOBER

   Database Connection Information

 Database server        = DB2/AIX64 9.7.6
 SQL authorization ID   = DB2
 Local database alias   = GOOBER

db2 => GET DATABASE MANAGER CONFIGURATION

          Database Manager Configuration

     Node type = Database Server with local and remote clients

 Database manager configuration release level            = 0x0d00

 CPU speed (millisec/instruction)             (CPUSPEED) = 2.834065e-07

 Max number of concurrently active databases     (NUMDB) = 5
 Federated Database System Support           (FEDERATED) = YES
....
 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024)
 No. of int. communication channels   (FCM_NUM_CHANNELS) = AUTOMATIC(512)
 db2start/db2stop timeout (min)        (START_STOP_TIME) = 10

To pull the database configuration it’s almost identical, connect to your DB2:

$ db2
db2 => connect to GOOBER

   Database Connection Information

 Database server        = DB2/AIX64 9.7.6
 SQL authorization ID   = DB2
 Local database alias   = GOOBER

db2 => GET DATABASE CONFIGURATION

       Database Configuration for Database

 Database configuration release level                    = 0x0d00
 Database release level                                  = 0x0d00
....
 SMTP Server                               (SMTP_SERVER) =
 SQL conditional compilation flags         (SQL_CCFLAGS) =
 Section actuals setting               (SECTION_ACTUALS) = NONE
 Connect procedure                        (CONNECT_PROC) =
Share Button

IBM DB2 10.1 LUW manuals fixed to work with tablet/phone PDF readers like Aldiko

Aldiko Book Reader Premium Full v2.2.3.apkMany PDF readers for smart phones (Android/iphone) and tablets manage the pdf files Calibre_Logobased solely on the Title and Author fields in the PDF file. While for this is fine for your average book, it is not all that helpful with manuals that tend to have abbreviated or no data in the title/author fields. In the case of the manuals for IBM DB2 LUW 10.1, I’m unable to load the manuals for say v9.7 as they have the same Title/Author data.  I used the same method from SAP Sybase IQ 15.4 manuals fixed to work with tablet/phone PDF readers like Aldiko

Here are the IBM DB2 10.1 LUW manuals that I’ve ‘fixed’ to work with Aldiko. They are identical to the PDFs on IBM’s website with the exception of the PDF fields I mentioned previously.

NO COPYRIGHT INFRINGEMENT IS INTENDED. IBM, PLEASE FEEL FREE TO TAKE THESE AND HOST THEM.

DB2 10.1 LUW – Preparation Guide for DB2 10.1 Fundamentals Exam 610 – IBM, Inc_
DB2 10.1 LUW – Command Reference – IBM, Inc_
DB2 10.1 LUW – DB2 Connect User’s Guide – IBM, Inc_
DB2 10.1 LUW – Database Security Guide – IBM, Inc_
DB2 10.1 LUW – Developing ADO.NET and OLE DB Applications – IBM, Inc_
DB2 10.1 LUW – Data Movement Utilities Guide and Reference – IBM, Inc_
DB2 10.1 LUW – Spatial Extender User’s Guide and Reference – IBM, Inc_
DB2 10.1 LUW – Call Level Interface Guide and Reference Volume 1 – IBM, Inc_
DB2 10.1 LUW – SQL Procedural Languages_ Application Enablement and Support – IBM, Inc_
DB2 10.1 LUW – Call Level Interface Guide and Reference Volume 2 – IBM, Inc_
DB2 10.1 LUW – Developing Embedded SQL Applications – IBM, Inc_
DB2 10.1 LUW – SQL Reference Volume 1 – IBM, Inc_
DB2 10.1 LUW – Getting Started with Database Application Development – IBM, Inc_
DB2 10.1 LUW – Developing Java Applications – IBM, Inc_
DB2 10.1 LUW – Developing Perl, PHP, Python, and Ruby on Rails Applications – IBM, Inc_
DB2 10.1 LUW – SQL Reference Volume 2 – IBM, Inc_
DB2 10.1 LUW – Text Search Guide – IBM, Inc_
DB2 10.1 LUW – Developing User-defined Routines (SQL and External) – IBM, Inc_
DB2 10.1 LUW – Upgrading to DB2 Version 10.1 – IBM, Inc_
DB2 10.1 LUW – Globalization Guide – IBM, Inc_ DB2 10.1 LUW – What’s New for DB2 Version 10.1 – IBM, Inc_
DB2 10.1 LUW – Installing IBM Data Server Clients – IBM, Inc_
DB2 10.1 LUW – DB2 Connect Installing and Configuring DB2 Connect Personal Edition – IBM, Inc_
DB2 10.1 LUW – DB2 Connect Installing and Configuring DB2 Connect Servers – IBM, Inc_
DB2 10.1 LUW – DB2 Workload Management Guide and Reference – IBM, Inc_
DB2 10.1 LUW – XQuery Reference – IBM, Inc_
DB2 10.1 LUW – Installing DB2 Servers – IBM, Inc_
DB2 10.1 LUW – Message Reference Volume 1 – IBM, Inc_
DB2 10.1 LUW – Configuration Guide for Federated Data Sources – IBM, Inc_
DB2 10.1 LUW – Message Reference Volume 2 – IBM, Inc_
DB2 10.1 LUW – Administration Guide for Federated Systems – IBM, Inc_
DB2 10.1 LUW – Precompiler Customization – IBM, Inc_
DB2 10.1 LUW – Replication and Event Publishing Guide and Reference – IBM, Inc_
DB2 10.1 LUW – SQL Replication Guide and Reference – IBM, Inc_
DB2 10.1 LUW – ASNCLP Program Reference for Replication and Event Publishing – IBM, Inc_
DB2 10.1 LUW – Administrative API Reference – IBM, Inc_
DB2 10.1 LUW – Database Monitoring Guide and Reference – IBM, Inc_ DB2 10.1 LUW – Net Search Extender Administration and User’s Guide – IBM, Inc_
DB2 10.1 LUW – Getting Started with DB2 Installation and Administration on Linux and Windows – IBM, Inc_
DB2 10.1 LUW – Database Administration Concepts and Configuration Reference – IBM, Inc_
DB2 10.1 LUW – Partitioning and Clustering Guide – IBM, Inc_
DB2 10.1 LUW – Troubleshooting and Tuning Database Performance – IBM, Inc_
DB2 10.1 LUW – Administrative Routines and Views – IBM, Inc_
DB2 10.1 LUW – pureXML Guide – IBM, Inc_
DB2 10.1 LUW – Preparation Guide for Exam 611 – IBM, Inc_
DB2 10.1 LUW – Data Recovery and High Availability Guide and Reference – IBM, Inc_

Share Button

Native support of SQLite in Sybase PowerBuilder and PowerDesigner?

What I would love to see is native support for SQLite. http://www.sqlite.org

It is the most installed embedded database on the planet hands down.  Don’t believe me?  You know that Firefox web browser, Thunderbird newsreader, most Adobe products, Miro, etc all have it embedded?  – reference http://www.sqlite.org/mostdeployed.html

We use it extensively at work as:

  1. staging for mass data imports/exports/conversions
  2. local application ‘cache’ for large data sets
  3. projects that don’t require all the features of Sybase ASE (or Oracle for that matter)

One of the best features is that the database itself in platform independent… copy the db on to AIX from your Windows box … then on to your old Amiga … then on to your windows mobile device.  Getting the point?  🙂

I really wish Sybase would make it so that the Sybase ASE databases were truly platform and character set/sort order independent… but that is in another dream 😉

Not a blurb in the PowerDesigner/PowerBuilder manuals or anything

Share Button