Mittwoch, 16 of April of 2014

DB2 for z/OS

 Essential information of current versions of DB2 for z/OS

Documents (site property)

Quite out of date, but better than current official documents.
Filename: CA-Platinum-Quick-Reference.pdf (132 kB)
Beschriftung: Quick Reference to CA/Platinum Database Management Tools

Beschreibung: Quite out of date, but better than current official documents.

Last updated: Fri, 13 Apr 2012 21:39:21 +0200, downloads: 463.

With DB2 11 for z/OS users can create archive tables to manage historical data for existing tables that is not often referenced. Read more about ‘archive table’ - a new table type - and SQL techniques to process deleted data.
Filename: DB2-11-for-zOS-Archiving-Data.pdf (730 kB)
Beschriftung: DB2 11 for z/OS new way of archiving data: With DB2 11 for z/OS user can create archive tables to manage historical data for existing tables that is not often referenced. Read more about new table type called ‘archive table’.

Beschreibung: With DB2 11 for z/OS users can create archive tables to manage historical data for existing tables that is not often referenced. Read more about ‘archive table’ - a new table type - and SQL techniques to process deleted data.

Last updated: Thu, 06 Feb 2014 11:48:26 +0100, downloads: 40.

DB2 Cloning Tool integrates storage system volume fast-replication and automation to clone entire DB2 subsystems within the same or shared LPAR. DB2 Cloning Tool renames the data sets, updates the volume identities, and manages the DB2 metadata to allow the data to be used by a cloned DB2 subsystem quickly.
Filename: DB2-Cloning-Tool-for-zOS.pdf (159 kB)
Beschriftung: DB2 Cloning Tool integrates storage system volume fast-replication and automation to clone entire DB2 subsystems within the same or shared LPAR. DB2 Cloning Tool renames the data sets, updates the volume identities, and manages the DB2 metadata to allow the data to be used by a cloned DB2 subsystem quickly.

Beschreibung: DB2 Cloning Tool integrates storage system volume fast-replication and automation to clone entire DB2 subsystems within the same or shared LPAR. DB2 Cloning Tool renames the data sets, updates the volume identities, and manages the DB2 metadata to allow the data to be used by a cloned DB2 subsystem quickly.

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 473.

Essay on the interaction between DB2 and DFSORT with many details from numerous IBM sources.
Filename: DB2-and-DFSORT.pdf (345 kB)
Beschriftung: Essay on the interaction between DB2 and DFSORT with many details from numerous IBM sources.

Beschreibung: Essay on the interaction between DB2 and DFSORT with many details from numerous IBM sources.

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 506.

Summary of announced capabilities and features.
Filename: DB2-zOS-V10.pdf (249 kB)
Beschriftung: Summary of announced capabilities and features.

Beschreibung: Summary of announced capabilities and features.

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 454.

Verwendung von Apostroph und Hochkomma in DB2 for z/OS
Cobol Programmen (german only)
Filename: DB2-zOS-Quote-Apostroph.pdf (232 kB)
Beschriftung: Verwendung von Apostroph und Hochkomma in DB2 for z/OS (german only)

Beschreibung: Verwendung von Apostroph und Hochkomma in DB2 for z/OS Cobol Programmen (german only)

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 476.

Limiting Access to the Database Server using the Resource Limit Facility RLF, summer 2011
Filename: DB2-RLF-Resource-Limit-Facility.pdf (452 kB)
Beschriftung: Limiting Access to the Database Server

Beschreibung: Limiting Access to the Database Server using the Resource Limit Facility RLF, summer 2011

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 515.

All facts and limitation, even samples for using DSNTEP2 and DSNTEP4, some of IBM’s DB2 sample programs written in PL/I and part of the delivered software package
Filename: DB2-zOS-DSNTEP2-analysis.pdf (354 kB)
Beschriftung: All facts and limitation, even samples for using DSNTEP2 and DSNTEP4, some of IBM’s DB2 sample programs written in PL/I and part of the delivered software package

Beschreibung: All facts and limitation, even samples for using DSNTEP2 and DSNTEP4, some of IBM’s DB2 sample programs written in PL/I and part of the delivered software package

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 489.

All facts and limitation, even samples for using DSNTIAUL, one of IBM’s DB2 sample programs written in assembler and part of the delivered software package.
Filename: DB2-zOS-DSNTIAUL-analysis.pdf (357 kB)
Beschriftung: All facts and limitation, even samples for using DSNTIAUL, one of IBM’s DB2 sample programs written in assembler and part of the delivered software package.

Beschreibung: All facts and limitation, even samples for using DSNTIAUL, one of IBM’s DB2 sample programs written in assembler and part of the delivered software package.

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 510.

DB2 for z/OS Bufferpool - Begriffe, Grenzwerte, Tuning ((text in german only)
Filename: DB2-for-zOS-Bufferpool-Handling.pdf (155 kB)
Beschriftung: DB2 for z/OS Bufferpool - Begriffe, Grenzwerte, Tuning (text in german only)

Beschreibung: DB2 for z/OS Bufferpool - Begriffe, Grenzwerte, Tuning ((text in german only)

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 496.

Basic VSAM and SMS information, DB2’s usage of VSAM Cluster. sliding secondary allocation size, DB2 Limits, disk capacity, failures and more.
Filename: DB2-VSAM-Cluster-Management.pdf (399 kB)
Beschriftung: Basic VSAM and SMS information, DB2’s usage of VSAM Cluster. sliding secondary allocation size, DB2 Limits, disk capacity, failures and more.

Beschreibung: Basic VSAM and SMS information, DB2’s usage of VSAM Cluster. sliding secondary allocation size, DB2 Limits, disk capacity, failures and more.

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 492.

IBM DB2 z/OS und IBM Data Studio 3.1.1, Vortrag vor GSE Hamburg, April 2012, Copyright IBM Deutschland GmbH, Herr Christian Daser. Wir bedanken uns für die Bereitstellung der Präsentation.
Filename: DataStudio_30042012_311.pdf (6 MB)
Beschriftung: Präsentation der IBM Deutschland GmbH, Information Management for System z, vor der GSE in Hamburg im April 2012.

Beschreibung: IBM DB2 z/OS und IBM Data Studio 3.1.1, Vortrag vor GSE Hamburg, April 2012, Copyright IBM Deutschland GmbH, Herr Christian Daser. Wir bedanken uns für die Bereitstellung der Präsentation.

Last updated: Wed, 17 Oct 2012 20:52:35 +0200, downloads: 507.

Extended DB2 DRDA Security: Managing TCP/IP-based connection requests, Prepare requestors for access requests using extended security, IPNAMES, LOCATION, USERNAMES, Setting DB2 for z/OS DRDA AR to use encrypted passwords, Using ICSF on z/OS, Using PassTickets, How RACF Processes the Password or PassTicket, The role of TCPALVER system parameter, Troubles using PassTickets, Unable to obtain a PassTicket - 00D31059, Invalid PassTicket passed - 00F30085, Protected Users and PassTickets, Surrogate User Jobs Submission
Filename: Extended-DB2-DRDA-Security-aspects.pdf (822 kB)
Beschriftung: Various aspects of using extended DB2 DRDA security

Beschreibung: Extended DB2 DRDA Security: Managing TCP/IP-based connection requests, Prepare requestors for access requests using extended security, IPNAMES, LOCATION, USERNAMES, Setting DB2 for z/OS DRDA AR to use encrypted passwords, Using ICSF on z/OS, Using PassTickets, How RACF Processes the Password or PassTicket, The role of TCPALVER system parameter, Troubles using PassTickets, Unable to obtain a PassTicket - 00D31059, Invalid PassTicket passed - 00F30085, Protected Users and PassTickets, Surrogate User Jobs Submission

Last updated: Thu, 13 Mar 2014 13:44:06 +0100, downloads: 34.

A brief overview about elements, restrictions, influence on utilities and internal structure.
Filename: Usage-of-XML-data-in-DB2-V9-z.pdf (300 kB)
Beschriftung: A brief overview about elements, restrictions, influence on utilities and internal structure.

Beschreibung: A brief overview about elements, restrictions, influence on utilities and internal structure.

Last updated: Wed, 11 Apr 2012 00:21:53 +0200, downloads: 459.

Latest posts for DB2 for z/OS

Loading DB2 z/OS data into DB2 LUW in internal format (last modified 2014-03-27 by Gernot)
Loading data of DB2 z/OS internal format into a DB2 Linux/Unix/Windows database became very easy. Either you use DB2 Connect to connect from any DB2 Linux/Unix/Windows to DB2 for z/OS. But this costs you a separate license fee. For a distinct cla...

SQL playing with user id's (last modified 2014-03-18 by Gernot)
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed: [crayon-534edb9b9c7bd958188721/] In this sample the SQL's have to check incoming userid's for having .. ...

db2jcc_license_cisuz.jar JCC JDBC (last modified 2014-03-16 by Gernot)
Accessing DB2 for z/OS or DB2 for iSeries from client on DB2 for Linux/Unix/Windows? Do you  experience troubles accessing then remote server database? Missing a license file? How to install and custimize? DB2 JDBC driver is not licensed for con...

New document "Extended DB2 DRDA Security" available (last modified 2014-03-13 by Gernot)
Extended DB2 DRDA Security: Managing TCP/IP-based connection requests Prepare requestors for access requests using extended security IPNAMES LOCATION USERNAMES Setting DB2 for z/OS DRDA AR to use encrypted passwords Using ICSF...

Job Scheduling on Windows - White Paper (last modified 2014-03-01 by Gernot)
The purpose of the white paper is to compare mainframe-based and distributed-based job schedulers and to assess the readiness of Microsoft Windows-based job scheduling technology to manage workloads at the enterprise level. The paper can also help IT...

15th DB2 Symposium 28-30 May 2013, Netherlands (last modified 2014-03-01 by Gernot)
The DB2 symposium fills the gap between classic conferences and workshops. In classic conferences many topics are covered, but each speaker has only a limited time for each topic. Interaction between speakers and attendees is normally restricted. In ...

SQL functions to convert DEC to HEX value (last modified 2014-02-14 by Gernot)
Do you need to convert decimal value to hexadecimal representation? Then you should try this: [crayon-534edb9b9d014229152116/]   Sample data displayed in a GUI (e.g. DbVisualizer):   The result is of type VARBINARY. You c...

List of important APAR's for DB2 z/OS (last modified 2014-02-13 by Gernot)
Work File http://www-01.ibm.com/support/docview.wss?uid=swg1PM17336 Enhancement of the process for creating Work File table spaces during installation and migration. DB2 9 and 10 for z/OS http://www-01.ibm.com/support/docview.wss?uid=isg1II1458...

CA Performance Handbook for DB2 for z/OS (last modified 2014-02-06 by Gernot)
The "CA Performance Handbook for DB2 for z/OS" handbook helps DB2 performance tuners to complete the following tasks: Design databases for high performance. Understand how DB2 processes SQL and transactions, and tune those processes for perfo...

New document: DB2 11 for z/OS new way of archiving data (last modified 2014-02-06 by Gernot)
New document published: DB2 11 for z/OS new way of archiving data DB2 11 for z/OS new way of archiving data: With DB2 11 for z/OS user can create archive tables to manage historical data for existing tables that is not often referenced. Read more a...

Don’t miss …