Tags

We're very happy to announce the availability of our open IBM Knowledge Center Beta, live on ibm.com (there is no need for a VPN connection!). You can access IBM Knowledge Center here: www.ibm.com/support/knowledgecenter/ The Beta will run from today until the end of February 2014. Improving your technical content experience IBM Knowledge Center is our new technology designed to bring IBM's technical publications together in a single location, and will replace our individual IBM Information Centers. For this... [More]

Hello All, Looking for some help on how to resolve the error DB2JAVIT : RC = 9505. Then you're in luck because we have put together the following tech doc to help you with that: Error DB2JAVIT : RC = 9505 upon opening a DB2 GUI tool Still seeing the error or have questions about it, then please feel free to comment below.

We all know how important it is to have the data spread across few tablespaces in order to speed up the backup. DB2 utilizes IO parallelism during the backup by processing multiple tablespaces at the same time (BACKUP ... PARALLELISM <N>). E.g. if you would have 10 tablespaces and go with parallelism 5, DB2 will spawn 5 buffer manipulator EDUs (db2bm) that will read 5 tablespaces in parallel (with the help of prefetchers). Once given db2bm is done with a tablespace, it will pick up the next one from those, which were not backed up yet.... [More]

Continuous availibility is the concept that enables 24/7 access to IT-enabled business functions, processes and applications. And minimizing planned downtime is what business and IT departments consider seriously nowadays. Especially, minimizing and setting the appropriate downtime is a bit challenging decision in case of DB2 version upgrade or migration to another system, because we also need to consider the time for getting back to original system in preparation for any unexpected problem after the planned change works. ... [More]

Are you interested in helping to shape future enhancements to IBM Support Portal, Fix Central, My notifications,
Service Request, and other online tools? The IBM Electronic Support user experience team is currently recruiting
clients to participate in design reviews and usability testing. You can choose from several different opportunities to participate: Drive requirements for the future What: Join the 2013 IBM Electronic Support Client Advisory Panel Who: Ideal for clients who support
or use at least one IBM product and who... [More]

Once you find DB2 HADR ( High Availability Disaster Recovery ) operation is somehow slow, what's the next ? You may want to narrow down if this delay is from writing to transaction log disk subsystem or something on network communication. Here is a sample scenario. - Intermittently, the number of 'commit active' status applications spikes. - Application team reports this has very serious impact even though that status stays very short 1 second period. ( Application processes increasing with High CPU consumption due to... [More]

This is a problem I met last year, I just get the time to write it down, hope it helps! I have a pureScale with 8 members, say member 0,1,2,3,4,5,6,7, and I have some applications running on a web application server will access a database on this pureScale, the application server manages a database connection pool, and the applications share the database connections within the pool. The design of the connection pool is setting connection count to 1000, and workload should be evenly distributed to 8 members. I know workload... [More]

Hello! We often get a question from customers "How to find the version of DB2 JDBC driver they are using?" Answer is simple, you need to run below command: The following command will retrieve the JCC driver version if executed from the command line: java com.ibm.db2.jcc.DB2Jcc -version Or for drivers that are not yet installed: java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version For eg. Once you find the DB2 JDBC driver version, next question will be, "What DB2 release it belongs to?" We have... [More]

Are you considering ‘Admin move table’ for reorganization work of your tables ? And are you finding the way to reduce time of last ‘SWAP’ of admin move table work ? Nowadays, our database systems have so many number of tables and the tables are getting bigger. And as a database administrator, we are facing the reality that we need to do the time consuming work for maintaining huge tables and business departments usually do not permit enough time to work on those on weekends offline maintenance work time windows.... [More]

File locking is an essential concept for insuring data integrity. It is quite common for programs to 'lock' files to make sure that what they read is accurate or to prevent anyone from reading or writing the file that they are modifying. Because of that it might happen that your program fails to acquire a lock on a file. While some programs will handle this silently by retrying to obtain the lock some might report an error, hang waiting to acquire the lock or simply terminate. Most users know about the 'fuser'... [More]

IBM DSM helps administer, monitor, manage and optimize the performance of IBM DB2® for Linux, UNIX and Windows databases as well as other environments. It gives database administrators (DBAs) and other IT staff the information they need to proactively manage performance and prevent problems before they impact the business. Plus, it is cloud-ready, can be deployed quickly and easily. DSM is available to you with your existing IBM DB2 license. Please join Ashok Kumar, Technical Lead for DSM, for a demo of DSM and how it can help you... [More]

Before data is inserted into a table, an insert search algorithm examines the free space control records (FSCRs) to find a page with enough space for the new data. But how the FSCR search mechanism works when several threads are inserting – does each thread do it’s own independent search (ie. potentially searching in parallel so theoretically more threads would be faster, discounting other contention), or will the threads queue and search one at a time (therefore more threads would simply queue and therefore not be any faster)? Ans:... [More]

This is one of the latest interesting issue s we have debugged in the lab where we performed analysis of core file, related db2 source code and diagnostic data. S haring some key points of this strange issue. Initial Symptom was - whenever a connection is made to the database, it crashes the db2 instance. When trying to understand scope of this issue, it was noted that there were more issues on this machine ( i .e scope was not just limited to one specific db2 instance/database): - Any db2 instance/database... [More]

Happy New Year! As we start the new year, we would like to hear from you on what topics/subject areas you would like to see blogs for, to make it easier for to you work with DB2 LUW and grow your skills. Please provide a comment here or send me an email and we will get our experts to write them. Thank you for your support and look forward to your suggestions. Regards Robert Lee Manager, DB2 LUW Technical Support eMail: robe rt.l ee@a u.ib m.co m

Need online technical queries answered now for your IBM DB2 products running on Linux, Unix and Windows (LUW)? Please post your queries in the IBM dWAnswers forum for DB2 for our worldwide IBM DB2 experts as well as the user community to assist you. If you are an expert DB2 user, please feel free to contribute to the forum and make IBM developerWorks the premium spot for DB2 LUW queries and information. Thank you for your support and would love to read your suggestions, comments or feedback. Regards Robert... [More]

The basic rules: 1. When a transaction log is full and/or closed db2 will archive the log (assuming an archiving method is defined in LOGARCHMETH1). 2. When a transaction log no longer contains an open unit of work (i.e. it's extent number is less than the First Active Log) and it has been archived successfully it can be renamed and reused. 3. As a general rule, the minimum number of logs allocated at database activation is LOGPRIMARY. The maximum number of logs that will be allocated to handle a large transaction is LOGPRIMARY + LOGSECOND.... [More]

One way to find record length in a specific table in a specific schema is to run following query, $ db2 "select tabname, sum(length) from syscat.columns where tabschema='<schema>' and tabname='<table-name>' group by tabname" Example with a DB2 LUW sample database table : $ db2 describe table db2inst1.org... [More]

Altered a tablespace to add space and then trying to rebalance the tablespace with command like, db2 alter tablespace <tablespace> rebalance But, the "db2 list utilities show detail" or, "db2pd -utilities" does not show any rebalance is running. The tablespace shows the status to be, Tablespace State = 0x'10000000' Detailed explanation: DMS rebalancer is active Following two command run successfully, ALTER TABLESPACE tablespace_name... [More]

what is a latch? Db2 is a multi threaded application written using the imperative programming model. Like any other multi threaded application, Db2 has its own mechanism to protect the common address base shared among the threads. It can be explained by the below given diagram: - In the diagram, two threads are updating the same structure in the memory but the consistency is kept by latches. Next question for any Db2 DBA would be, what is different than lock/wait? It is an internal implementation of Db2 to protect... [More]