WebSphere Sensor Events 6.2 Location Awareness Services Interim fix IC79226

Downloadable files


Abstract

Interim fix IC79226 resolves an issue that causes an error to occur in the database script that is used to clean up history tables.

Download Description

The database script that is used to clean up old records in the following history tables contains an error:

  • HIST.CURRENTTAGS
  • HIST.TAG2ZONES
  • HIST.AREAZONELIST
The script deletes all history entries that are older than a specified time and for which newer data is available. The error prevents the script from cleaning up the tables, which causes the tables to expand without limit.

The SQL command error is caused by a missing column in the declaration of the temporary table. To resolve the error, the interim fix adds the SEQUENCENO column as shown in the following code:

DB2 "DECLARE GLOBAL TEMPORARY TABLE TEMP_TAG_DEL_DATA (TAGID VARCHAR(32),TAGTYPE CHARACTER(1), X_COORD DOUBLE, Y_COORD DOUBLE, Z_COORD DOUBLE, SPEED DOUBLE, YAW DOUBLE, PITCH DOUBLE, ROLL DOUBLE, BAT SMALLINT, CREDAT TIMESTAMP, TIME_IN_SEC BIGINT, TIME TIMESTAMP, VGRPID VARCHAR(64), HUBID INTEGER, IGNORECNT INTEGER, CLASSID INTEGER, ITEMID INTEGER, STATIONARY SMALLINT, ALERT CHARACTER(1), BUTTONS VARCHAR(16), ICONLINK VARCHAR(255), ICONLABEL VARCHAR(255), UPDATEINTERVAL INTEGER, VIRTUALZONE CHARACTER(1), CRUD CHARACTER(1), EXTENDED_ATTR VARCHAR(1024), CONTAINER SMALLINT, SEQUENCENO BIGINT) ON COMMIT PRESERVE ROWS NOT LOGGED WITH REPLACE IN ATLASTEMP"

Prerequisites

For prerequisites, refer to the readme document in the Fix Central download package.

Installation Instructions

For installation instructions, refer to the readme document in the Fix Central download package.

Download package


Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
What is Fix Central (FC)?
Interim fix APAR IC79226 02 Feb 2012 English 3129 FC

Problems (APARS) fixed
IC79226

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Sensor Events
Location Awareness Services for WebSphere Sensor Events

Software version:

6.2

Operating system(s):

Windows, Windows 2003 server

Reference #:

4031852

Modified date:

2013-01-22

Translate my page

Machine Translation

Content navigation