Slakshmi 060001JD9S Visits (1136)
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:
There are three forms of the LIST DCS APPLICATIONS command, as follows:
kdillon 20000024FQ Visits (900)
Slakshmi 060001JD9S Visits (932)
Two new Security Vulnerabilities fixed in V9.7 FP6:
Security Bulletin : Unauthorized file access in the DB2 XML feature
The fix for this vulnerability is available for download for DB2 release V9.7 Fix Pack 6.
wbratton 120000E4TY Visits (899)
Expert Advice: InfoSphere Streams ODBCDBG Failed to set isolation level
If you receive "ODBCDBG Failed to set isolation level" when trying to connect InfoSphere Streams to an Oracle database. This problem occurs because the Streams default isolation level for the query element is "REA
Expert Advice: Selecting the Bookmark listing from the Alphablox Blox Menu Cuts Off a Long Bookmark List
wbratton 120000E4TY Visits (728)
ubektas 27000478GM Visits (1423)
You can click on the link to access the site for this interesting book
gorddbds 060001JCXS Visits (1753)
DB2 LUW provides two ways of determining if you are using the product according to the licenses you have installed. One is the dblicm tool the other is the ENV_FEATURE_INFO administrative view. The db2licm -l command lists the product and feature licenses installed for each DB2 product at the same build level as the instance the command was run under. For example the following is db2licm -l output from a DB2 version 9.7 ESE instance.
Product name: "DB2 Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.7"
Enforcement policy: "Soft Stop"
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization: "Licensed"
DB2 Advanced Access Control: "Not licensed"
DB2 Geodetic Data Management: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
The db2licm -g <filename> command will generate a compliance report containing the products installed, the features available for the products and their usage status. The following is an example of the file created by db2licm -g command.
License Compliance Report
DB2 Enterprise Server Edition In compliance
DB2 Database Partitioning: "Not used"
DB2 Performance Optimization ESE: "Not used"
DB2 Storage Optimization: "In compliance"
DB2 Advanced Access Control: "Not used"
DB2 Geodetic Data Management: "Not used"
IBM Homogeneous Replication ESE: "Not used"
The ENV_FEATURE_INFO administrative view returns information similar to the db2licm -g command. To use the administrative view connect to a database and run the following query.
SELECT * FROM
Below is an example of the ENV_FEATURE_INFO output.
In the examples, both the db2licm and ENV_FEATURE_INFO output indicate that the DB2 Storage Optimization feature has been used and is licensed. If a feature had been used at least once but not licensed the output would show its status as “In violation”. Features that have not been used will have a status of "Not used".
Further information on the ENV_FEATURE_INFO administrative view and the db2licm command can be found at the following URL.
For additional information on DB2 LUW Licensing see the License Issues Knowledge Collection at the following URL.
ubektas 27000478GM Visits (967)
After upgrading to IIS 8.5 FP2 , Does Datastage Designer derivation editor in the transformer stage emit error "Unexpected error; quitting"
If yes,it is a known issue and refer to the technote
As mentioned in the technote you might apply temporary fix or installing the patch by contacting IBM Support for the fix
ubektas 27000478GM Visits (955)
It might happen that you are not able to list the installed ODBC driver in the Microsoft ODBC Datasource Administrator tool on your Windows
The reason of that Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
- The 32-bit version of the Odbcad32.exe file is located in the %sys
- The 64-bit version of the Odbcad32.exe file is located in the %sys
You need to run the appropriate Odbcad32.exe to see list of Datadirect ODBC drivers installed on your Windows Operating System
You might visit the technote for details
ubektas 27000478GM Visits (929)
You need to choose right bitness of Information Server Pack for SAP BW 184.108.40.206 that was installed on 64 bit Linux server to avoid installation problems
To uninstall the 32 bit Pack components from a 64 bit Linux or UNIX server,please follow the steps:
1. Go to the DSSE
The default for DSSERVERDIR is /opt
2. Type the uninstaller.bin command.
Note: To uninstall in console mode, type the uninstaller.bin -console command.
3. If InfoSphere Information Server services tier is installed on a different computer from InfoSphere Information Server engine tier, use the following steps to uninstall the Pack documentation:
a. On the computer where the services tier is installed, go to the DSSE
The default for DSSERVERDIR is opt/
b. Type the uninstaller.bin command.
Note: To uninstall in console mode, type the uninstaller.bin -console command
please refer to recently published technote for that
carose 2700021P0Q Visits (1055)
When creating a new instance. DB2 requires the group ID to fall into the range of 100-65535. If the group ID doesn't fall in that range the instance creation will fail. You will see an error similar to below.
This means special care is needed for those systems with a large number of users and groups. Such as those who utilize LDAP, or Microsoft Active Directory. Special care should be taken to ensure that users and groups should be given ID's greater than the 65535 limit, so that this issue will not be hit.
DBI1446I The db2icrt command is running, please wait.
DB2 installation is being initialized.
The GID specified for the group "db2test" is invalid. Enter a valid
KateDawson 060001TQ2C Visits (771)
We may be biased, but we can’t imagine being an IBM Software customer and not subscribing to the IBM Software Newsletter. If that logic alone sways you, stop reading and subscribe now. If you need more reasons, try these:
1. It’s the easiest way to stay current on all IBM software – including software made specially for System z and Power Systems.
2. It’s refreshingly low-maintenance – actually, it’s no-maintenance. You don’t have to ‘follow,’ ‘like,’ or ‘friend’ anybody or anything to read the IBM Software Newsletter. All you have to do is subscribe, and it arrives in your inbox every month.
3. It can make you a smarter software customer and a better software user. Every issue connects you to valuable resources created by IBM and industry experts – analyst reports, e-books, demos, webcasts, podcasts, videos, briefs – that can help you choose the right software for your business, and get more from that software every day.
4. It’s customizable. When you subscribe, just check off the types of IBM software or solutions you’re interested in. We’ll beef up your newsletter with extra content based on the interests you select.
5. Special editions! If you choose, you can receive four (4) System z Editions or two (2) Power Systems editions of the newsletter per year, as part of your subscription. These special editions are ‘front-loaded’ with news and resources about IBM software made specifically for your hardware.
6. It connects you to savings. The IBM Software Newsletter is an excellent way to stay informed about discounts on IBM software, training, event fees and more.
7. It covers the big events. We publish complete recaps of every flagship IBM software conference – including Lotusphere, Pulse, Impact, Innovate, and Information On Demand.
8. It’s FREE. Sure, most email newsletters are free. But very few free newsletters contain as much valuable content as the IBM Software Newsletter.
9. It’s easy – and smart – to share. Every issue comes with a link you can click to send a copy of the newsletter to a friend or colleague. (It turns out that friends and colleagues really like this.)
10. There’s no obligation. If you read The IBM Software Newsletter and decide it isn’t for you, just unsubscribe – you’ll never receive another issue again. Unless you reconsider and subscribe again.
Clearly, this is a win-
KateDawson 060001TQ2C Visits (1220)
We have completed our series of 100 technical support tips! See our blog to mark the end of the series here!
A few of you have asked for a full summary of our tips broken down by product area... so here you go!
kdillon 20000024FQ Visits (898)
amccarl 100000AY2G Visits (705)
Now that we've "categorized" our 100 Tech Tips with tags to help you find them, how do you find them?
Easy - just click on a tag!
You can also search using your favorite search engine using "developerWorks" plus the tag.
Either way, you'll get straight to our posts. Now that was easy!