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. >db2licm -l Product name: "DB2 Enterprise Server Edition"... [More]

Tags:  compliance license im_techtip

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    

Tags:  im_resource infosphere

  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 %systemdrive%\Windows\SysWoW64 folder. - The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder. You need to run... [More]

Tags:  infosphere im_advice

You need to choose right bitness of Information Server Pack for SAP BW 4.3.2.1 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 DSSERVERDIR/_uninst/eapacks/sapbw directory. The default for DSSERVERDIR is /opt/IBM/InformationServer/Server. 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... [More]

Tags:  tip infosphere tech

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.    Reproduction: root@test #... [More]

Tags:  im_advice

Top 10 reasons to subscribe to the IBM Software Newsletter 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... [More]

Tags:  im_resource

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!  DB2 #7: DB2 License key #8: DB2 on LUW Problem Determination Guides #10: Common DB2 Security Issues #14: New Explain feature in DB2 9.7: section explain & ... section actuals #16: Where can I find the NES 32 and 64 bit index migation tool for Windows? #18: Frequently Asked DB2 Questions #19: New to DB2 for LUW? Looking for trial... [More]

Tags:  summary im_resource

On 5/14/2012, three new IBM Education Assistant modules went to production.  These modules are related to the InfoSphere Master Data Management Collaboration Server.  How to install Master Data Management Collaboration Server 10.0 - Explains the installation of IBM InfoSphere® Master Data Management Collaboration Server. How to install sample portal package - Explains how to install the sample portal package that comes by default in the IBM InfoSphere® Master Data Management Collaboration Server. How to configure the env_settings.ini file -... [More]

Tags:  mdmcs mdm im_resource infosphere

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!                                                                 Searching for one of our tags in developerWorks will also return our documents. Category Description Searchable tag Tech Tip Posts that are highly technical in nature im_techtip Resource Info Posts where we share a support resource available to you im_resource Expert Advice Posts that include expert advice/guidance from our support team... [More]

Tags:  im_resource

There are two approaches to table reorganization:  classic reorganization  (offline) and  inplace reorganization  (online). During offline reorganization as the name suggests, you do not have access to the table where as an inplace table reorganization enables you to reorganize a table while you have full access to its data. To specify an online reorganization operation, use the INPLACE option on the  REORG TABLE  command. Classic table reorganization uses a shadow copy approach, building a full copy of the... [More]

Tags:  monitor db2 reorg im_techtip inplace offline

How to run REORG table command from a CLI application against a DB2 database server?   REORG command is supported by command line processor, you cannot use the REORG command directly from a CLI application. In order to run REORG from a CLI application, you will have to use ADMIN_CMD stored procedure. For example: CALL SYSPROC.ADMIN_CMD ('REORG TABLE test')   ADMIN_CMD - DB2 V9.1 ADMIN_CMD - DB2 V9.5 ADMIN_CMD - DB2 V9.7     If you try to use the REORG command from a CLI application, it will return SQL0104N (syntax error). You will find a... [More]

Tags:  im_techtip cli reorg db2

Bye Bye, Control Center! So, what's next?   Starting from DB2 Version 9.7, Control Center tools have been deprecated. In DB2 Version 10.1, Control Center tools and all the related components such as wizards and advisors are discontinued.   The following Control Center tools and related features have been discontinued: Activity Monitor Command Editor Configuration Assistant Control Center and associated wizards and advisors Add Partitions launchpad Alter Database Partition Group wizard Backup wizard Configuration advisor wizard Configure... [More]

Tags:  im_advice replacement conrol deprecated center

Things to know about db2connectactivate Server Activation Tool: You can obtain db2connectactivate license key from DB2 Connect Unlimited Edition for system z via DB2 Connect Unlimited Edition for System z CD or By downloading the IBM DB2 Connect 9.7, Unlimited Edition for System z Quick Start and Activation for Linux, UNIX and Windows - CI36DML from Passport Advantage Refer to:  DB2 Version 9.7 Activation key part numbers To be more specific, this utility is present under ~\consv_zs\db2\license directory Note: db2connectactivate is... [More]

Tags:  db2 im_advice im_techtip db2connectactivate

You have setup a HADR database and it is in peer state, if your primary server goes down how does the client connect to the standby server ?    You can use automatic client reroute with HADR to make client applications connect to the new primary database after a takeover operation. If automatic client reroute is not enabled, client applications will receive error message SQL30081. Automatic Client Reroute (ACR) enables a DB2 client application to recover from a loss of communications so that the application can continue its work with minimal... [More]

Tags:  acr automatic hadr reroute im_techtip db2 im_advice client