IT31560: DBSCHEMA -D -T MISSED TO GENERATE THE AM PART FOR TS VTI TABLES CREATED BY TSCREATEVIRTUALTAB

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels