You're invited to our September Support Technical Exchange! Topic: IBM PureData for Analytics (Netezza) Connectivity for Information Server DataStage Speaker: Scott Brokaw, Information Server Support Engineer, Team Lead Date: Tuesday, September 30, 2014 Time: 11:00am - 12:00pm EDT Description: Extend data integration and governance in IBM PureData for Analytics by fully leveraging InfoSphere Information Server. This presentation will provide a connectivity and quick start guide for Netezza Connectivity within Information Server... [More]
New IP&S IBM Education Assistant content available - Relocating Information Server 9.1 xmeta and xmetasr repositories with a WebSphere cluster . Related techdoc ID is #7041974 . The objectives of this presentation are to describe the databases and repositories that Information Server version 9.1 includes, how to check what you need to relocate, what you need to back up, and how to update xmeta and xmetasr including the Information Services Framework configuration, referred to as the ISF... [More]
Is enableSysplexWLB (Sysplex Workload balancing JDBC driver property) a data source property or a driver wide (global) property? Answer) enableSysplexWLB is not a driver-wide or a global property, so you cannot set it in the JCC properties file. These are properties starting with "db2.jcc.*" and "db2.jcc.override.*". The "db2.jcc." properties provide a driver wide default value. It is a Data source or connection level property, so it can only be enabled programmatically inside the application via a... [More]
How to restore critical administrative files with onbar utility? It is already known to us that onbar backs up some critical administrative files during storage space backup. These critical files are as follows: The onconfig file UNIX: The sqlhosts file The ON-Bar emergency boot file: ixbar.servernum The server boot file: oncfg_servername.servernum There may be a situation when you need to restore one of these files, for example: replace disks, restore to a second computer system (imported restore) etc. However, previously there was no easy way... [More]
Have you tried taking DB2 database backup and restoring it in DPF using Single System View? DB2 Version 9.5 (or later) provides the Single System View (SSV) function which allows backing up multiple database partitions at once. In earlier releases, partitioned databases needed to be backed up one partition at a time which can be time consuming and prone to errors. The backup timestamp associated with all database partitions is the same. I am listing down the commands with minimum clauses to illustrate how SSV can be used.... [More]
Hi there! When you open a Problem Management Record (PMR) with DB2 Support team, first thing we are interested in looking at is db2support.zip. Its a great handy tool collecting background information on your environment. Ever wondered what it has? Extracting the db2support.zip file, the following files and directories were collected: DB2CONFIG/ - Configuration information (for example, database, database manager, BP, CLI, db2 node configuration and Java developer kit, among others) The files have “supp_cfg” as the file... [More]
The Power of Collecting Your IBM software isn't working as you expected it to, so you're ready
to call IBM Support to get the help you need. Before you pick up the
phone, search the IBM knowledge base and see if there is a Collecting
Data document related to your situation. Collecting data documents (formerly MustGather documents) aid in
problem determination and save time resolving problems by explaining
what information needs to be gathered before calling IBM. Collecting data documents are an extension of the natural
There is recently published redbook "InfoSphere DataStage for Enterprise XML Data Integration" that guides you trough XML integration in Datastage and contains few chapters about the XML Stage in detail. These chapters describe how the XSD maps to the schema structure in XML Stage, Schema Library Manager, creating/composing/transforming XML documents and also the use of the other steps in XML Stage. There is also a separate chapter for Datastage performance and XML You can click on the link to access the site for this interesting book... [More]
Are you IBM Certified? If you answered no, you can change that answer to a yes at IOD! All registered customers and business partners can take one complimentary exam at the conference! That's a value of $200 USD. Complimentary exams can be from the Information Management, Business Analytics and Enterprise Content Management catalogs. Subsequent tests will be offered at the discounted price of $30. Exams for IBM Cloud, Collaboration, Rational, Security, SOA,Tivoli, WebSphere, and XML will be available at $100 per certification exam.... [More]
One of our clients has a JCC application going through a DB2 Connect gateway connecting to DB2/Z database, instead of direct connection to DB2/Z. They wanted to know how to setup the automatic client re-route(ACR) if the DB2 Connect goes down. Here are the steps: Common Step: In the case of the DB2 Connect server, because there is no requirement for the synchronization of local databases, you only need to ensure that both the original and alternate DB2 Connect servers have the target IBM mainframe database cataloged in such a way that it... [More]
Here is a list of the Top Ten viewed technical documents for DB2 for Linux, Unix, and Windows: 12 Oct 2010: DB2 Fix Packs by version for DB2 for Linux,...
20 Jul 2010: DB2 Version 9.5 Fix Pack 5 for Linux, UNIX,...
26 May 2010: DB2 database product documentation
30 Aug 2010: DB2 UDB Version 8 - End of Support date is...
23 Feb 2010: DB2 UDB Version 8 Product Manuals
01 Jul 2010: DB2 UDB Version 8 FixPaks & client downloads...
16 Sep 2010: DB2 Version 9.7 Fix Pack 1 for Linux, UNIX,...
16 Mar 2010: DB2 Version 9.1 for Linux,... [More]
Check this out! Here is a full list of Developer Works articles on DB2 for Linux, Unix and Windows Optimizer that our experts have published to this date which you may find useful. 1) Get the most out of DB2 optimizer: Leveraging statistical views to improve query execution performance 2) Recreate optimizer access plans using db2look 3) ... [More]
100 Tech Tips, #59: Collecting the right data for MDM Support team PD Collector tool is a great way to collect all the information MDM Support Team will need for investigation purposes. Please note this PD Collector tool ( Problem Determination Tool ) is available from MDM Server 902 onwards. All you need to do is running the "mdmsupport.sh" script with any of the available options. Here some examples: - mdmsupport.sh --collect=mdm (collects info from MDM layer) - mdmsupport.sh --collect=appserver (collects info from the... [More]
Do you know how to get the status of the section of a package in DB2, here's an easy command to retrieve this information by querying the system catalogs: DB2 on zos: Verify the status of the section from DB2 Client against DB2 zos by issuing the below statement: (Normally this is handy when SQ0525N bind error occurs) db2 "select contoken, SEQNO, STMTNO , SECTNO, STATUS FROM SYSIBM.SYSPACKSTMT WHERE COLLID = 'NULLID' AND NAME = 'SQLUAK20'" C Compiled -... [More]