• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates

Thoughts from Support

  • Log in to participate

About this blog

Part of the IBM Analytics family, focused on support for IBM Analytics products. This blog is administered by Kate Nichols and follows the IBM Social Computing Guidelines.
  • Facebook
  • Twitter
  • Google
  • LinkedIn
  • RSS

Archive

  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010

Tags

All posts
  • Sort by:
  • Date
  • Title
  • Likes
  • Comments
  • Views ▼

100 Tech Tips, #100 CLASSIC REORG vs INPLACE REORG

John Gera 2700020XST | | Visits (10798)

Tweet
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

Swati Thorve 270004FTYS | | Visits (10791)

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

lisettecontreras 060000M7T8 | | Comment (1) | Visits (10775)

Tweet
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

Biswarup(Bis)Mukherjee 120000HKTY | | Comments (2) | Visits (10222)

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

KateDawson 060001TQ2C | | Comments (7) | Visits (10136)

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

KateDawson 060001TQ2C | | Visits (9993)

Tweet
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

SangeetaB 270007FX5Y | | Comment (1) | Visits (9964)

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

Andrew McCarl 100000AY2G | | Comment (1) | Visits (9959)

Tweet
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

lisettecontreras 060000M7T8 | | Comment (1) | Visits (9944)

Tweet
 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

Subbu Prabhu 060001JD9S | | Visits (9926)

Tweet
  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

Jun Su Lee 27000725GN | | Comments (4) | Visits (9871)

Tweet
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

wbratton 120000E4TY | | Comment (1) | Visits (9842)

Tweet
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

MaryKKassey 2700055CKK | | Comment (1) | Visits (9820)

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

Chris Rose 2700021P0Q | | Comment (1) | Visits (9813)

Tweet
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

John Gera 2700020XST | | Visits (9726)

Tweet
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
  • Show:
  • 10
  • 20
  • 30
  • Previous
  • Next
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61