New InfoSphere Information Server education in Knowledge Center - Relocating Information Server 9.1 InfoSphere DataStage® and QualityStage® operations database (DSODB) . Related techdoc #7041980 . This presentation discusses how to relocate the InfoSphere® DataStage® and QualityStage operations database to another server. It assumes that you are still using the same services tier to manage repository registration in the same metadata repository. This presentation is valid for... [More]
Inoperative DB2 Package: Packages in DB2, can be dependent on certain types of database objects such as tables, views, aliases, indexes, triggers, referential constraints and table check constraints. If a package is dependent on a database object (such as a table, view, trigger, and so on), and that object is dropped, the package is placed into an invalid state. If the object that is dropped is an UDF, the package is placed into an inoperative state. For an inoperative package, in the SYSCAT.PACKAGES system catalog view, the VALID column shows:... [More]
100 Tech Tips: #82: Find IBM Netezza on the Support Portal! Attention IBM Netezza Clients: You can now search for and select IBM Netezza in the Support Portal to find IBM Netezza information, technical documents, sign up for automated notifications about your Appliance, and open service requests. Click this link to access the Support Portal with IBM Netezza already selected in your product list. As you become familiar with the Portal, here are a few tips: The following images are from the Support Home tab of the Portal. Click the Find... [More]
There are multiple ways to migrate to InfoSphere Information Server, Versions 8.5, 8.7, or 9.1 depending on the version of InfoSphere DataStage or InfoSphere Information Server you are migrating from, the InfoSphere Information Server products installed, and other factors. IBM offers a Concierge Program for free to provide guidance on the best approach to migrate to Information Server, Version 8.5, Version 8.7, or Version 9.1. The Concierge Program is offered to all customers, but it is particularly important for customers using the InfoSphere... [More]
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]
Looking for options to monitor the remote client connections
in a DB2 Connect gateway and want to uniquely identify the remote application
connected to the DB2 Connect? There are two options: Using
the GET SNAPSHOT commands: There are five snapshot commands useful for monitoring DCS
information. They are: GET
SNAPSHOT FOR ALL DCS DATABASES GET SNAPSHOT FOR ALL DCS
APPLICATIONS GET SNAPSHOT FOR DCS
APPLICATION ... GET SNAPSHOT FOR DCS DATABASE
ON db_alias GET SNAPSHOT FOR DCS
APPLICATIONS ON db_alias... [More]
As a technical professional, you need to leverage many different sources of technical information to stay on top of the latest software developments. Today we ask you... are you reading IBM Redbooks? IBM Redbooks publications are developed and published by the IBM
International Technical Support Organization (ITSO). The ITSO develops
and delivers skills, technical know-how, and materials to IBM technical
professionals. IBM Redbooks are the ITSO's core product. They typically provide
guidance, installation and implementation... [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]
Hello! Last week, I ran into a customer problem where the 32-bit ODBC User DSN test from 32-bit ODBC Data Source Administrator (C:\Windows\sysWow64\odbcad32.exe) for a remote database running on AIX was failing with below error with 32-bit DB2 Data Server Driver Package 9.7 FP0 on Windows 7 64-bit: We tried to create a new User DSN from 32-bit ODBC Data Source Administrator, but we could not, since it failed with the same error. On their Windows XP, machine they have the same setup, the DSN test connection works fine, only on... [More]
Do you want to learn more about InfoSphere Streams and Big Data? Take a look at Roch Achambualt’s IBM InfoSphere Streams 2.0 presentation. The presentation introduces Streams. It provides Streams Application examples along with an overview Streams Processing Language and Streams Toolkits. The presentation provides links to the following: Streams Wiki an online information hub for InfoSphere Streams users Streams Exchange a place for Streams application developers to share ideas, source code, design patterns, experience reports and rules... [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]
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]
Rocks, Paper, Scissors? Heads or Tail? Good guess's but none of the above. A tiebreaker is a object used in a DB2 HA (High Availability) cluster environment comprised of even number of nodes. In such a cluster environment, when both nodes cannot communicate with each other, the tiebreaker is used by both nodes to see which node is still active and can continue to host cluster resources. This in essence, is " breaking a tie ", hence, a tiebreaker. Tiebreaker requirements A tiebreaker must be accessible from all nodes in the... [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]