100 Tech Tips, #100 CLASSIC REORG vs INPLACE REORG
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 inplace reorg db2 im_techtip offline |
Tech Tip: How to resolve SQL0428N when SQL statement is unknown
Hi there! SQL0428N error is easy to resolve provided you have actual SQL statement causing the error. Here is more information about actual error message link SQL0428N The SQL statement is only allowed as the first statement in a unit of work. User response Issue a COMMIT or ROLLBACK prior to processing the SQL statement. If there are any WITH HOLD cursors, these will need to be closed. If the statement is SET INTEGRITY, remove the COMMIT THRESHOLD clause. Adding a COMMIT or ROLLBACK prior to SQL statement generally resolves the issue. But what... [More]
|
What IBM InfoSphere Guardium can do to protect your business ?
Have you heard about IBM InfoSphere Guardium or Guardium product as it is usually called? If not, read below a brief description of what this product can do to protect your database access with a powerful product. Or, if you have heard or have experience using the product, please share your experiences. What is IBM InfoSphere Guardium: It is a product that can be a combination of dedicated hardware (appliance) and software or just software (a virtual appliance plus additional software) . It provides a solution for
assuring the privacy and... [More]
Tags:  security guardium monitoring attacks activity database |
How to find record length in a table in DB2 LUW
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]
Tags:  record length db2 |
IBM Knowledge Center Open Beta is available!
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]
Tags:  beta open knowlege-center |
IOD 2012: Connect with Subscription & Support and AVP!
IOD 2012 is now just around the corner! If you haven’t registered yet for this year’s conference, you can do so by clicking here . And once you’re registered, get ready to Think BIG! As always, IBM Software Subscription & Support and the Accelerated Value Program will be at the event and ready to meet with you. Here are ways to connect with us at the event:
Subscription & Support: Renew, Recharge, Resolve… RESTORED Discover how you can get even more value from your software investment through Subscription & Support (S&S). By... [More]
Tags:  im_events ibmiod |
Weekly Tips from DB2 Experts: Determine what DB2 products are installed on your system
Here is a simple DB2 command which will display the DB2 products that are installed on the system: db2ls - it displays the Install path, product level, fix pack details, Special Install Number, Installation date , Installer UID. The db2ls command is the only method to list all DB2 product at Version 9 or later. However you cannot use the db2ls command on Windows operating systems. $ db2ls Install... [More]
Tags:  products db2_techtip path db2level db2 |
New Video - How IBM uses Knowledge-Centered Support (KCS)
New Video - How IBM uses Knowledge-Centered Support (KCS) In Information Management Technical Support, we've invested a lot of time, training, and effort improving our Knowledge Base by implementing Knowledge-Centered Support (KCS). I'm excited that a new video has been posted which helps explain the KCS process in IBM: Together, we are making support better!
Tags:  db2 im esupport kcs |
100 Tech Tips, #3: What IBM InfoSphere Guardium can do to protect your business
IBM Infosphere Guardium is gaining momentum. More and more customers are using it to implement a robust monitoring and security solution for their environments. If you want to learn more about IBM InfoSphere Guardium you can start here: http...s://www-304.ibm.com/support/docview.wss?uid=swg27020137&aid=1 IBM InfoSphere Guardium 8.0 Quick Start Guide If you have questions and/or need assistance with this product, IBM's Technical Support can help. Check out the link below for a summarized guide on how to contact IBM Infosphere Guardium... [More]
Tags:  security protect guardium |
Tech Tip: Setting up the UnixODBC driver manager and ODBC environment for DB2
An ODBC driver manager is not supplied on UNIX platforms as part of the operating system. Using ODBC on UNIX systems, therefore, requires a separate commercial or open source ODBC driver manager. The unixODBC Driver Manager is an open source ODBC driver
manager for use on UNIX platforms.
This driver manager is supported for ODBC applications on supported DB2® platforms.
To run ODBC applications on Linux or UNIX operating systems, you must configure the UnixODBC Driver Manager. Here are the steps to install and configure UnixODBC for... [More]
Tags:  db2 unixodbc |
50 DB2 Nuggets #14 : Expert Advice - Continuous availability and DB2 migration using InfoSphere Replication Server
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]
Tags:  50_db2_nuggets server replication db2 infosphere migration upgrade irs db2_advice |
Expert Advise: DB2 Alphablox 9.5.7 Fix Pack 4 is now available
Expert Advise: DB2 Alphablox 9.5.7 Fix Pack 4 is now available. This release provides the following: Support for the Essbase 11.1.2.1 - 64 bit bridge interface for Windows, Solaris and AIX. Browser support for Internet Explorer 9.0 and Firefox 9, and Firefox10 Click here to find out more about additional supported packages and fixes.
Tags:  advise business alphablox cubing monitor expert warehouse services |
50 DB2 Nuggets #1 : Tech Tip - Demystifying the db2ReadLog API
The db2ReadLog API is used to read log records from the DB2® database logs, or queries the Log Manager for current log state information. Before a Embedded SQLC program can be used it has to be precompiled, bound, compiled and linked. Here is an example on how to use the db2ReadLog API using the dblogconn.sqc sample SQLC program that is provide with the DB2 sample scripts. This program reads the database log files asynchronously with a database connection using the db2ReadLog API. Copy the sample c scripts from ~/sqllib/samples/c to local... [More]
Tags:  demystifying db2readlog db2_techtip api 50_db2_nuggets |
50 DB2 Nuggets #25 : Tech Tip - Upon load/import of data you may see additional data in the first row inserted.
Using a simple test case. This can be easily observed. Document was exported using a utility that applies a byte order mark to text documents. db2 "create table numbers (col1 char(10),col2 char(10),col3 char(10))" DB20000I The SQL command completed successfully. [db2v97@ts-carose2 ~]$ db2 import from numbers.csv of del insert into numbers SQL3109N The utility is beginning to load data from file "numbers.csv". SQL3110N The utility has completed processing. "2" rows... [More]
Tags:  load db2_techtip mark order byte 50_db2_nuggets import db2 export |
100 Tech Tips, #96 Automatic Client Reroute and HADR
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:  db2 im_advice automatic im_techtip acr reroute hadr client |