In a purescale environment TSA is used to monitor the various resource that need to be running to ensure a healthy purescale system.   It might happen that some of these resource fail. If that is the case you want to find out which one it is and take proper actions. Sometimes it's not easy to navigate the various files to find out what happened.   This small document will use a live example to show you how to do it.   When a problem occurs it will be reported in the system log files that can be viewed using 'errpt... [More]

Etiquetas:  tsa timeout db2

I am sharing this as we had a situation lately in a big 3 member 2 CF Purescale setup where there were hangs in the members being experienced without much notable reasons. When checked the setup closely it was found out the DB2SLEEP registry was turned ON in this instance for some reason and it was left that way accidentally.   DB2SLEEP is an internal undocumented registry setting used only by Db2 Support team for advanced level of diagnostics collection.   The registry will put the instance in the sleep state so that more... [More]

Etiquetas:  hang db2luw db2sleep

This small script will show you how you can track a process' children activity. It tracks all children that use 'exec()' for a given executable. Then for each one of those children it will print the 'exit()' code and for the parent it will track the 'waitpid()' status after a child is gone.   This script can be used for example to track the activity from TSA related to db2 on a purescale system. It will show all the monitor commands executed by TSA to monitor the purescale system.   The script should be... [More]

This small script will track calls to 'sigaction()' for a given signal and executable. This might become useful when a program does not react as expected when receiving a signal. This might be because somewhere along the way, something might have reset the signal disposition using a call to 'sigaction()'.   Since such call can be also performed from an external API loaded via a dynamic library, this script will catch as well the 'dlopen()' and 'dlclose()'. Also it will print the address at which the... [More]

Etiquetas:  sigaction probevue

Sometimes we get confused if particular db2 registry variable takes effect immediately or requires db2 instance recycle. So here is the quick command that you can run: db2set -info <db2_registry_variable_name>   Example:  $ db2set -info DB2_REDUCED_OPTIMIZATION    Immediate change supported : YES     Immediate by default :       NO      Please note '-info' option with db2set is available since db2 v10.1 onwards. In fact, we started supporting '-immediate'... [More]

If you upgrade your database from v9.7 to upper level and revoke a role from a user, you might see the following error message due to orphan rows in system tables.   ------------------------------------------------ $ db2 revoke role developer_role from user db2user1 DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL0901N  The SQL statement or command failed because of a database system error. (Reason... [More]

Customer wrongly removed the Operating System on one cf host , now they need to stop the service and drop it from cluster  , how to do next ?  Following is the scenario in customer's real case , the procedure contains how to achieve the purpose and how to solve the problem we hit during the process , record here for you to follow or refer to  . 1. We can use  "db2stop cf 129 force" and "db2stop instance on p780k8 force"to stop the service 2. db2sdin1@p780k5_KEHUA:/home/db2sdin1> db2instance -list... [More]

(We have technote below to online change IP address , customer followed the steps , it's not progress unfortunately .) http://www-01.ibm.com/support/docview.wss?uid=swg21594983 Following procedure is got by working with GPFS team and has already validated by customer ,  note that this is a completely offline operation . 1. As an instance user, perform the following steps:     1). Stop the database manager on all hosts by issuing the following command on a single host:     su -iname    ... [More]

Some years ago, I wrote a blog about using 'STMTID' to track long term performance changes for SQLs. ( Blog link : 'STMTID' - The key for long term performance tracking of an SQL ) Has anyone of you ever applied to your system ? Intermittently, I have gotten personal contacts asking to give some examples showing how it works. So here let me introduce very simple examples just to share what I meant. To remind, ' mon_get_pkg_cache_stmt ' function has... [More]

Etiquetas:  performance

When float/double data type number is converted to decimal data type, some digits might be truncated by the precision and scale parameter in decimal data type definition. In this situation, db2 mode and oracle mode use different policies like as follows. 1. db2 mode : digits are just  truncated from the end of the decimal number if the number of digits to the right of the decimal separator character is greater than the scale scale . 2. oracle mode : digits are truncated based on the DECFLT_ROUNDING  in db cfg.     For... [More]

QUESTION: Could you guide us how to use administrative task scheduler ADMIN_TASK_ADD and ADMIN_TASK_REMOVE? We found each usage at KC but could not locate any sample usage case at the internet. ANSWER: Before using it, it is suggested to review below KC page for finding out the outline. The administrative task scheduler https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.gui.doc/doc/c0054380.html ... The administrative task scheduler enables DB2R database servers to automate the execution of tasks. It also provides a... [More]

Etiquetas:  db2support db2 db2luw

QUESTION: ========= There is V11.1 online manual available at: DB2 database product documentation http://www-01.ibm.com/support/docview.wss?uid=swg27009474 but could not find any link for PDF manuals as V10.5, V10,1, V9,8. Here is an example, V10.5 for your reference: DB2 database product documentation http://www-01.ibm.com/support/docview.wss?uid=swg27038430 ... DB2 documentation available online and downloads DB2 documentation updates DB2 documentation as PDF manuals Best practices for DB2 for Linux, UNIX, and Windows ... When will V11.1 PDF... [More]

Etiquetas:  db2support db2luw db2

  There is a common misconception that db2dart is only an offline tool.   To understand the truth we have to understand 2 things:  that db2dart only reads data from disk and that there are 3 distinct types of db2dart options.      The answers begin by understanding that db2dart only reads data that is stored on disk.  This can cause issues when multiple pages are compared, such as during an inspection operation.   For example, if db2dart is validating a table and a user has inserted a row... [More]

Etiquetas:  offline db2dart online

  Abstract IBM is pleased to announce a new support option available to you when your software reaches End of Service (EOS). IBM will offer Continuing Support for selected Analytics(Db2,Informix,ILG, ECM&Cognos) products and releases. This offering will provide you with continued access to the same knowledgeable global Support team you are working with today. Content IBM is pleased to announce a new support option available to you when your software reaches End of Service (EOS). IBM will offer Continuing Support for selected Analytics... [More]

Etiquetas:  support ecm cognos continuing db2 analytics ilg