Freitag, 25 of April of 2014

Category » DB2 for Linux/Unix/Windows

Neuer DB2 Newsletter 2014/01 (german)

For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv!

Themen: Neues in DB2 V10.5, Migration von Row- zu Column-Organized Tabelle, Load Problem, Redirected Restore als Methode der Migration, Von V9.7 nach 10.5, Migration nach UTF-8 Datenfelder, DB2 Regionale Usergroup.

Hier geht’s zum IBM DB2 Newsletter Archiv!

New “DB2 administrator’s Unix Commands Survival Sheets” available

New document (PDF) “DB2 administrator’s Unix Commands Survival Sheets” available:

All UNIX commands DB2 administrators know but hardly remember. Covers some Solaris and most of the relevant AIX commands. Also covers some SAP R3 commands for SAP base administrators. Includes Some monitoring commands like top|topas, nmon, db2top. Also important code pages included.

DB2 Administrator’s Unix Commands Survival Sheets

Firefox users will possibly have troubles reading the PDF document using the imbedded PDF viewer. Invoke an alternative reader!

Loading DB2 z/OS data into DB2 LUW in internal format

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 class of DB2 LUW server (e.g. on AIX) IBM supplies the DB2 Connect Enteprise license, which costs even more.
  • Or just use existing infrastructure components: UNLOAD or DSNTIAUL your data at z/OS, transport (e.g. SCP, SFTP ) your data in binary format and LOAD, IMPORT or INGEST data at DB2 for Linux/Unix/Windows. Following sample will show you how it works.

Assume following DB2 structrure of a sample table:

Then unload your DB2 z/OS data using DSNTIAUL. SYSPUNCH will show you the columns locations you will need later:

Then transport SYSRECnn dataset to Linux/Unix/Windows in binary format. Use SCP or SFTP for example.

Then LOAD sample data into your DB2 Linux/Unix/Windows database. Specifiy codepage of origin, e.g. 819 or 237. Also specify optional keywords BINARYNUMERICS and PACKEDDECIMAL to allow loading data in IBM proprietary data formats. If you are using NULL indicators you have to specify as NULLINDCHAR.

Restrictions may exist for CLOB, XML and other ‘advanced’ data types.

SQL playing with user id’s

Does your application has to check cerrtain authorzation id’s for certain access rights needed? Following SQL shows some ways how to proceed:

In this sample the SQL’s have to check incoming userid’s for having ..

  • L0nnnnnn or F0nnnnnn
  • where n=0-9
  • except first letter should not have any other letter or special character

Any comment? Do not hesitate to provide YOUR solution! Send your suggestions to!

db2jcc_license_cisuz.jar JCC JDBC

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?

SQL to determine automatic table maintenance Events

Automatic table maintenance work? When? How often? For which tables?

These SQL queries will help to clarify questions of this kind.


Job Scheduling on Windows – White Paper

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 organizations that plan to migrate mainframe workloads to the Windows Server platform as part of a legacy modernization initiative.

This paper opens with a review of the market for job scheduling, followed by a brief outline of its growth path. Detailed comparisons of a selection of both mainframe-based and distributed-based job scheduling products provide the basis for analyzing job scheduling capabilities on each type of platform. It also looks at two products on the market that offer JCL emulation on the Windows Server platform. It concludes with a glimpse at what Microsoft is doing with scripting and task scheduling.

Custom Research Note, Dr. Mike Gilbert, Legacy Directions
Technical Review: Michael Dee Hester, Microsoft
Published: December 2006

Read Word DOC here.

For the latest information, please see .

IBM DB2 Autonomics – A Practical Guide to DB2 Autonomic Features in SAP Environments

This excellent guide describes how  autonomic features can help to make database administration as easy and low-cost as possible.

The basis for the descriptions and recommendations in this paper is database version DB2 9.7. If there are commands or SQL-statements that are related to other versions, the specific version is explicitly mentioned.

The authors are members of IBM SAP DB2 Center of Excellence.


Read more.

Avoiding Database REORG Operations in SAP Systems on DB2 for Linux, UNIX, and Windows Version 10.1

An excellent SAP document describes how to avoid database REORG operations in SAP Systems operating with DB2 10.1 LUW

Techniacal environment: SAP NetWeaver 7.0 and higher on DB2 for Linux, UNIX, and Windows (DB2 for LUW) version 10.1 or higher.

Document Summary: Database tables with frequent INSERT, UPDATE and DELETE operations become fragmented over time. This fragmentation causes problems in terms of performance and space reclamatio n. To alleviate these problems the database administrator starts a table and/or index reorganization which is a heavy operation and has an impact on the avail ability of that table or index . DB2 10.1 offers new features that help to a void reorganizations. This document discusses the usag e of insert time clustering tables, index space reclamation and smart data and inde x prefetching in SAP systems running on DB2 10.1.

Owner and source of document: SAP

Link: Click here.


Neuer DB2 Newsletter 2013/02 (german)

For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv!

Themen: Was ist neu in DB2 10.5 for Linux/Unix/Windows, Command dbstart nach Übernahme, DB2 Abfrage Optimierung durch OPTIMIZATION GUIDELINES, DB2 Bind Files und Package Namen, New Feature in DB2 V10.1 FP3, Chats mit dem Labor, Schulungen / Tagungen / Informationsveranstaltung u.v.m.

Hier geht’s zum IBM DB2 Newsletter Archiv!