Skip to main content

Software  >  Information Management  >  Informix product family  >  

Potential erroneous error messages or wrong results on multiprocessor POWER5 and POWER6 systems
 Flash (Alert)
 
Abstract
Red Brick may produce erroneous results, data corruptions, assertions and internal errors when running Red Brick 6.30.FC1 through 6.30FC11 versions on systems with multiple POWER5 and POWER6 CPUs
 
Content
PROBLEM
When running Red Brick on POWER5 and POWER6 CPUs wrong results, data corruption, assertions, internal errors and hung loads may result. These problems may occur sporadically and with differing probability of occurrence as described below:

Occurrence Probability
Symptom
High
Parallel queries produce wrong results, assertions or internal errors
Parallel aggregation maintenance produce corrupt data, assertions or internal errors
DML (insert, update, delete), DDL (alter, clear) in parallel queries or aggregate maintenance produce corrupt data, assertions or internal errors
Load or Reorg with aggregate maintenance produce corrupt data, assertions or internal errors
Medium
Parallel Reorg produces corrupt tables and indexes, incorrect number of duplicates, or wrong discards
Parallel Reorg hangs
Load or Reorg with aggregate maintenance generate invalid aggregates
Low
Errors on non-versioned loads produce corrupt tables and indices
Load or restore from standard label tape produces corrupt tables and indexes


SCOPE

Customer systems with ALL of the following may experience this problem:
  • POWER5 and POWER6 CPUs
  • Multiple CPUs
  • Red Brick version 6.30.FC1, 6.30.FC2, 6.30.FC3, 6.30.FC4, 6.30.FC5, 6.30.FC6, 6.30.FC7, 6.30.FC8, 6.30.FC9, 6.30.FC10 or 6.30.FC11
  • Enabled parallel processing in query and reorg


SOLUTION


If you have:
Upgrade to:
6.30.FC1, 6.30.FC2, 6.30.FC3, 6.30.FC4, 6.30.FC5, 6.30.FC6, 6.30.FC7, 6.30.FC8, 6.30.FC9, 6.30.FC10 or 6.30.FC11
6.30.FC11.R1 and later


WORKAROUNDS

For queries

Turn parallelism OFF; do this by setting QUERYPROCS as described below:
  1. Open the rbw.config file in a text editor
  2. Uncomment and set the TUNE QUERYPROCS value to 0
  3. Save the rbw.config file
  4. Stop and start Red Brick.

All subsequent connections will now use the updated value.


For problems with the loader

Use serial loader (rb_tmu) to perform reorg operations.
 
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Data Management
 Data Servers (Database Management Systems)
 Red Brick Warehouse
 Operating system(s):
  AIX
 Software version:
  6.3
 Reference #:
  1377445
 IBM Group:
 Software Group
 Modified date:
 2009-03-13

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.