APAR status
Closed as Permanent restriction.
Error description
In an TimeSeries environment, VTI tables can be created by the use of the Function tscreatevirtualtab . E.G create row type blog_row_t ( tstamp datetime year to fraction(5), col1 integer ); create table blog ( id char(50) not null primary key, data timeseries(blog_row_t) ); execute procedure tscreatevirtualtab("blog_vti", "blog", "calendar(ts_15min), origin(2020-01-15 00:00:00.00000), threshold(0), regular"); After then a VTI table is created bound to a specified base table. Running an dbschema -d -t on the VTI table creates the following schema create table "holgerk".blog_vti ( id char(50) not null , tstamp datetime year to fraction(5), col1 integer ); revoke all on "holgerk".blog_vti from "public" as "holgerk"; So a subsequent recreate (dbexport) of the table creates a standard empty table with no link to the original base table.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * tscreatevirtualtab * **************************************************************** * PROBLEM DESCRIPTION: * * dbschema -d -t missed to generate the AM part for TS VTI * * tables created by tscreatevirtualtab * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Not needed by customer
Temporary fix
Comments
APAR Information
APAR number
IT31560
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-01-17
Closed date
2022-10-10
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024