There is an MKS Update (JR41641) to upgrade IIS 8.5 and later to the new MKS toolkit 9.4fp1 + hotfix CFS31959 that resolves several problems including issues with jobs hanging or failing under high CPU loads This upgrade replaces the one in APAR JR39847
Hello! Often DBAs asks us to how to find when the routine was run last time? This helps them in finding all the unused SPs, functions and take necessary action on them. Most of the routines create packages. It is easy to find last execution time of the routine by joining three catalog views: syscat.packages syscat.routinedep syscat.routines You can use the below query: db2 select rt.routineName as RoutineName, pkg.lastused LastUsed from syscat.routines rt, syscat.routinedep rd, syscat.packages pkg where rt.specificname =... [More]
Importing large business glossary files, such as the XML files provided with IBM Industry Models, might fail due to exceeding the timeout values set in WebSphere Application Server and InfoSphere Information Server. You can change these values so that the import succeeds. Please refer to the technote for more details
What is an orphan row in DB2 system catalog tables? Orphan rows in system catalog tables are entries for which corresponding dependent entry in another sytem catalog table is missing Example: Let's consider a SAMPLE database which has table DEPARTMENT and view VDEPT. There will be records in SYSIBM.SYSTABLES for DEPARTMENT and a dependency record in SYSIBM.SYSVIEWDEP for VDEPT db2 "select creator, name from sysibm.systables where name='DEPARTMENT'" CREATOR NAME ----------------------------- SKHARCHE DEPARTMENT 1 record(s)... [More]
PewResearch Center published the results of their latest Big Data study on the internet. The report discusses what experts are saying about Big Data hype and hope. Mark Wash co-founder of Geniusrocket.com is quoted as saying “IBM Smarter Planet will make energy use and traffic congestion get better”. The report provided the following quote from the McKinsey Global: “US health care could use Big Data creatively and effectively to drive efficiency and quality, we estimate that the potential value from data in the sector could be more than... [More]
Hello! Recently I had opportunity to play around db2audit tool. db2audit tool is DBA's best friend when it comes find all the activities going on in database. DB2® database systems provide an audit facility to assist in the detection of unknown or unanticipated access to data. The DB2 audit facility generates and permits the maintenance of an audit trail for a series of predefined database events. For more information about db2audit command, refer Information Center db2audit can be divided in 5 main steps as : 1> Configure 2>... [More]
James Kobielus, Senior Program Director for IBM's Big Data Analytics, is interviewed by Scott Laningham. During the interview Mr. Kobielus discusses why big data is so important, the role of Apache Hadoop and IBM BigInsights in making sense of big data, the evolving role of the data scientist, and and where data warehousing and big intelligence fit in. Click the here to view the interview video
IBM InfoSphere Information Server Unified Update Installer, Version 126.96.36.199 is available at IBM Support FixCentral The Information Server Unified Update Installer is used to install fixes, fix packs, and updates to InfoSphere Information Server and its product modules. There is a separate download available for each Operating Systems Follow the online instructions to install and use the Update Installer. This Update Installer package is for versions 8.7 and 9.1 installed on Windows platforms . Follow the online instructions to install and use... [More]
The KCS Shift and the Information Shuffle - is that a new dance? For Information Management Support, it is. Throughout 2009, a tremendous amount of time and effort went into shifting Information Management Support teams to using a Knowledge-Centered Support, or KCS, model. I hear you asking "KCS, what does that mean?" The basic premise: if information is useful to resolve one problem or question, then it's probably good for other problems or questions as well. Easy enough? Well, it's a little more complicated behind the... [More]
Hello all, Did you know that you can chat with a DB2 tech support analyst right after opening a PMR using our new tech chat interface. Find out more here: Click here to learn more! We are standing by waiting to help you! If you have used or are having trouble using this option please comment below.
Andrew wanted to let you know about some new information that has been posted to iiug2014.org about this year's conference. Sessions are now available at iiug2014.org/sessions.php Hands on Labs are now available at iiug2014.org/hol.php Tutorials are now available at iiug2014.org/tutorials.php Keynote Speakers this year will be Beth Smith, General Manager IBM Information Management and good friend of the IIUG Jerry Keesee, Director of IBM Informix Development. You can find... [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]
A new IBM Education Assistant module for the Optim Development Studio products went to production Friday, 6/1/2012. This presentation covers the steps to create a connection profile for the Optim Directory and to create the Optim Directory Project.