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]

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

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

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 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

  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)   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

 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

  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

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.  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

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

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

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