-- @@@ START COPYRIGHT @@@
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements.  See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership.  The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License.  You may obtain a copy of the License at
--
--   http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied.  See the License for the
-- specific language governing permissions and limitations
-- under the License.
--
-- @@@ END COPYRIGHT @@@
;
--===================================--
--  Create data base objects used in --
-- TPCD SF100 plan selection tests.  --
--===================================--

?section obeys
-------------------------------------
-- Obey system specific defines.   --  
-------------------------------------
obey PSETDEFS;

?section crCatSch
------------------------------------------------- 
--  Create catalog and schema for TPCDF.SF100F --
-- database if it doesn't already exist.       --
------------------------------------------------- 
#ifMX
create catalog TPCDF;
create schema TPCDF.SF100F;
#ifMX

?section startLog
----------------------------
--  Start logging output. --
----------------------------
LOG aoptddl02 clear;

?section setSCH
-----------------------------------------
-- Set fake schema for rest of script. --
-----------------------------------------
#ifMX
set schema TPCDF.SF100F;
#ifMX

?section customer
---------------------------
-- Create Customer Table --
---------------------------
#ifMX
Create table customer  (
   c_custkey           int                not null not droppable, 
   c_name              varchar(25)        not null not droppable, 
   c_address           varchar(40)        not null not droppable, 
   c_nationkey         int                not null not droppable, 
   c_phone             char(15)           not null not droppable, 
   c_acctbal           numeric(12,2)      not null not droppable, 
   c_mktsegment        char(10)           not null not droppable, 
   c_comment           varchar(117)       not null not droppable, 
primary key (c_custkey)  not droppable) 
store by primary key
location $$partition2$$
partition ( 
   add first key (         234001) location $$partition1$$,
   add first key (         468001) location $$partition2$$,
   add first key (         702001) location $$partition2$$,
   add first key (         936001) location $$partition1$$,
   add first key (        1170001) location $$partition1$$,
   add first key (        1404001) location $$partition2$$,
   add first key (        1638001) location $$partition2$$,
   add first key (        1872001) location $$partition1$$,
   add first key (        2106001) location $$partition1$$,
   add first key (        2340001) location $$partition2$$,
   add first key (        2574001) location $$partition2$$,
   add first key (        2808001) location $$partition1$$,
   add first key (        3042001) location $$partition1$$,
   add first key (        3276001) location $$partition2$$,
   add first key (        3510001) location $$partition1$$,
   add first key (        3744001) location $$partition2$$,
   add first key (        3978001) location $$partition2$$,
   add first key (        4212001) location $$partition1$$,
   add first key (        4446001) location $$partition1$$,
   add first key (        4680001) location $$partition2$$,
   add first key (        4914001) location $$partition2$$,
   add first key (        5148001) location $$partition1$$,
   add first key (        5382001) location $$partition1$$,
   add first key (        5616001) location $$partition2$$,
   add first key (        5850001) location $$partition2$$,
   add first key (        6084001) location $$partition1$$,
   add first key (        6318001) location $$partition1$$,
   add first key (        6552001) location $$partition2$$,
   add first key (        6786001) location $$partition1$$,
   add first key (        7020001) location $$partition2$$,
   add first key (        7254001) location $$partition2$$,
   add first key (        7488001) location $$partition1$$,
   add first key (        7722001) location $$partition2$$,
   add first key (        7956001) location $$partition2$$,
   add first key (        8190001) location $$partition1$$,
   add first key (        8424001) location $$partition1$$,
   add first key (        8658001) location $$partition2$$,
   add first key (        8892001) location $$partition2$$,
   add first key (        9126001) location $$partition1$$,
   add first key (        9360001) location $$partition1$$,
   add first key (        9594001) location $$partition2$$,
   add first key (        9828001) location $$partition2$$,
   add first key (       10062001) location $$partition1$$,
   add first key (       10296001) location $$partition1$$,
   add first key (       10530001) location $$partition2$$,
   add first key (       10764001) location $$partition1$$,
   add first key (       10998001) location $$partition2$$,
   add first key (       11232001) location $$partition2$$,
   add first key (       11466001) location $$partition1$$,
   add first key (       11700001) location $$partition1$$,
   add first key (       11934001) location $$partition2$$,
   add first key (       12168001) location $$partition2$$,
   add first key (       12402001) location $$partition1$$,
   add first key (       12636001) location $$partition1$$,
   add first key (       12870001) location $$partition2$$,
   add first key (       13104001) location $$partition2$$,
   add first key (       13338001) location $$partition1$$,
   add first key (       13572001) location $$partition1$$,
   add first key (       13806001) location $$partition2$$,
   add first key (       14040001) location $$partition1$$,
   add first key (       14274001) location $$partition2$$,
   add first key (       14508001) location $$partition2$$,
   add first key (       14742001) location $$partition1$$)
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.CUSTOMER (
   c_custkey           int                not null,
   c_name              varchar(25)        not null,
   c_address           varchar(40)        not null,
   c_nationkey         int                not null,
   c_phone             char(15)           not null,
   c_acctbal           numeric(12,2)      not null,
   c_mktsegment        char(10)           not null,
   c_comment           varchar(117)       not null,
primary key (c_custkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition ( 
   $VDP002.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         234001) ,

   $VDP003.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         468001) ,

   $VDP004.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         702001) ,

   $VDP005.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         936001) ,

   $VDP006.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        1170001) ,

   $VDP007.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        1404001) ,

   $VDP008.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        1638001) ,

   $VDP009.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        1872001) ,

   $VDP010.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        2106001) ,

   $VDP011.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        2340001) ,

   $VDP012.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        2574001) ,

   $VDP013.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        2808001) ,

   $VDP014.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        3042001) ,

   $VDP015.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        3276001) ,

   $VDP016.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        3510001) ,

   $VDP017.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        3744001) ,

   $VDP018.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        3978001) ,

   $VDP019.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        4212001) ,

   $VDP020.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        4446001) ,

   $VDP021.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        4680001) ,

   $VDP022.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        4914001) ,

   $VDP023.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        5148001) ,

   $VDP024.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        5382001) ,

   $VDP025.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        5616001) ,

   $VDP026.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        5850001) ,

   $VDP027.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        6084001) ,

   $VDP028.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        6318001) ,

   $VDP029.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        6552001) ,

   $VDP030.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        6786001) ,

   $VDP031.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7020001) ,

   $VDP032.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7254001) ,

   $VDP033.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        7488001) ,

   $VDP034.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7722001) ,

   $VDP035.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7956001) ,

   $VDP036.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        8190001) ,

   $VDP037.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        8424001) ,

   $VDP038.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        8658001) ,

   $VDP039.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        8892001) ,

   $VDP040.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        9126001) ,

   $VDP041.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        9360001) ,

   $VDP042.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        9594001) ,

   $VDP043.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        9828001) ,

   $VDP044.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       10062001) ,

   $VDP045.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       10296001) ,

   $VDP046.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       10530001) ,

   $VDP047.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       10764001) ,

   $VDP048.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       10998001) ,

   $VDP049.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       11232001) ,

   $VDP050.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       11466001) ,

   $VDP051.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       11700001) ,

   $VDP052.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       11934001) ,

   $VDP053.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       12168001) ,

   $VDP054.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       12402001) ,

   $VDP055.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       12636001) ,

   $VDP056.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       12870001) ,

   $VDP057.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       13104001) ,

   $VDP058.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       13338001) ,

   $VDP059.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       13572001) ,

   $VDP060.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       13806001) ,

   $VDP061.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       14040001) ,

   $VDP062.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       14274001) ,

   $VDP063.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       14508001) ,

   $VDP064.$$NSK_SUBVOL$$.CUSTOMER
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       14742001) )

buffered audit;
#ifMP

?section cx1
------------------------------------------------
-- Create nation key index on customer table. --
------------------------------------------------
#ifMX
Create unique index cx1 on customer
(
     c_nationkey 
   , c_custkey 
)
location $$partition2$$
partition( 
add first key               3     location    $$partition2$$ ,
add first key               5     location    $$partition1$$,
add first key               7     location    $$partition1$$,
add first key               9     location    $$partition2$$ ,
add first key              11     location    $$partition2$$ ,
add first key              13     location    $$partition1$$,
add first key              15     location    $$partition1$$,
add first key              17     location    $$partition2$$ ,
add first key              19     location    $$partition2$$ ,
add first key              21     location    $$partition1$$,
add first key              23     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create unique index $$NSK_VOL$$.$$NSK_SUBVOL$$.CX1 on $$NSK_VOL$$.$$NSK_SUBVOL$$.CUSTOMER
(
     c_nationkey 
   , c_custkey 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key               3      ,

  $VDP003.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key               5      ,

  $VDP004.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key               7      ,

  $VDP005.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key               9      ,

  $VDP006.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key              11      ,

  $VDP007.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              13      ,

  $VDP008.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              15      ,

  $VDP009.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key              17      ,

  $VDP010.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key              19      ,

  $VDP011.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              21      ,

  $VDP012.$$NSK_SUBVOL$$.CX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              23      

)
buffered; 
#ifMP

?section lineitem
-----------------------------
-- Create line item table. --
-----------------------------
#ifMX
Create table lineitem  (
   l_orderkey          int                not null not droppable, 
   l_partkey           int                not null not droppable, 
   l_suppkey           int                not null not droppable, 
   l_linenumber        int                not null not droppable, 
   l_quantity          numeric(12,2)      not null not droppable, 
   l_extendedprice     numeric(12,2)      not null not droppable, 
   l_discount          numeric(12,2)      not null not droppable, 
   l_tax               numeric(12,2)      not null not droppable, 
   l_returnflag        char(1)            not null not droppable, 
   l_linestatus        char(1)            not null not droppable, 
   l_shipdate          date               not null not droppable, 
   l_commitdate        date               not null not droppable, 
   l_receiptdate       date               not null not droppable, 
   l_shipinstruct      char(25)           not null not droppable, 
   l_shipmode          char(10)           not null not droppable, 
   l_comment           varchar(44)        not null not droppable, 
primary key (l_orderkey,l_linenumber)  not droppable) 
store by primary key 
location $$partition2$$
partition ( 
   add first key (          2500001) location $$partition1$$,
   add first key (          5000001) location $$partition2$$,
   add first key (          7500001) location $$partition2$$,
   add first key (         10000001) location $$partition1$$,
   add first key (         12500001) location $$partition1$$,
   add first key (         15000001) location $$partition2$$,
   add first key (         17500001) location $$partition2$$,
   add first key (         20000001) location $$partition1$$,
   add first key (         22500001) location $$partition1$$,
   add first key (         25000001) location $$partition2$$,
   add first key (         27500001) location $$partition2$$,
   add first key (         30000001) location $$partition1$$,
   add first key (         32500001) location $$partition1$$,
   add first key (         35000001) location $$partition2$$,
   add first key (         37500001) location $$partition1$$,
   add first key (         40000001) location $$partition2$$,
   add first key (         42500001) location $$partition2$$,
   add first key (         45000001) location $$partition1$$,
   add first key (         47500001) location $$partition1$$,
   add first key (         50000001) location $$partition2$$,
   add first key (         52500001) location $$partition2$$,
   add first key (         55000001) location $$partition1$$,
   add first key (         57500001) location $$partition1$$,
   add first key (         60000001) location $$partition2$$,
   add first key (         62500001) location $$partition2$$,
   add first key (         65000001) location $$partition1$$,
   add first key (         67500001) location $$partition1$$,
   add first key (         70000001) location $$partition2$$,
   add first key (         72500001) location $$partition1$$,
   add first key (         75000001) location $$partition1$$,
   add first key (         77500001) location $$partition2$$,
   add first key (         80000001) location $$partition2$$,
   add first key (         82500001) location $$partition1$$,
   add first key (         85000001) location $$partition1$$,
   add first key (         87500001) location $$partition2$$,
   add first key (         90000001) location $$partition2$$,
   add first key (         92500001) location $$partition1$$,
   add first key (         95000001) location $$partition1$$,
   add first key (         97500001) location $$partition2$$,
   add first key (        100000001) location $$partition1$$,
   add first key (        102500001) location $$partition2$$,
   add first key (        105000001) location $$partition2$$,
   add first key (        107500001) location $$partition1$$,
   add first key (        110000001) location $$partition1$$,
   add first key (        112500001) location $$partition1$$,
   add first key (        115000001) location $$partition1$$,
   add first key (        117500001) location $$partition2$$,
   add first key (        120000001) location $$partition2$$,
   add first key (        122500001) location $$partition1$$,
   add first key (        125000001) location $$partition1$$,
   add first key (        127500001) location $$partition2$$,
   add first key (        130000001) location $$partition2$$,
   add first key (        132500001) location $$partition1$$,
   add first key (        135000001) location $$partition1$$,
   add first key (        137500001) location $$partition2$$,
   add first key (        140000001) location $$partition1$$,
   add first key (        142500001) location $$partition2$$,
   add first key (        145000001) location $$partition2$$,
   add first key (        147500001) location $$partition1$$,
   add first key (        150000001) location $$partition1$$,
   add first key (        152500001) location $$partition1$$,
   add first key (        155000001) location $$partition2$$,
   add first key (        157500001) location $$partition2$$)
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.LINEITEM (
   l_orderkey          int                not null,
   l_partkey           int                not null,
   l_suppkey           int                not null,
   l_linenumber        int                not null,
   l_quantity          numeric(12,2)      not null,
   l_extendedprice     numeric(12,2)      not null,
   l_discount          numeric(12,2)      not null,
   l_tax               numeric(12,2)      not null,
   l_returnflag        char(1)            not null,
   l_linestatus        char(1)            not null,
   l_shipdate          date               not null,
   l_commitdate        date               not null,
   l_receiptdate       date               not null,
   l_shipinstruct      char(25)           not null,
   l_shipmode          char(10)           not null,
   l_comment           varchar(44)        not null,
primary key (l_orderkey,l_linenumber) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition ( 
   $VDP002.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (          2500001) ,

   $VDP003.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (          5000001) ,

   $VDP004.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (          7500001) ,

   $VDP005.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         10000001) ,

   $VDP006.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         12500001) ,

   $VDP007.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         15000001) ,

   $VDP008.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         17500001) ,

   $VDP009.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         20000001) ,

   $VDP010.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         22500001) ,

   $VDP011.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         25000001) ,

   $VDP012.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         27500001) ,

   $VDP013.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         30000001) ,

   $VDP014.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         32500001) ,

   $VDP015.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         35000001) ,

   $VDP016.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         37500001) ,

   $VDP017.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         40000001) ,

   $VDP018.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         42500001) ,

   $VDP019.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         45000001) ,

   $VDP020.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         47500001) ,

   $VDP021.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         50000001) ,

   $VDP022.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         52500001) ,

   $VDP023.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         55000001) ,

   $VDP024.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         57500001) ,

   $VDP025.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         60000001) ,

   $VDP026.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         62500001) ,

   $VDP027.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         65000001) ,

   $VDP028.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         67500001) ,

   $VDP029.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         70000001) ,

   $VDP030.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         72500001) ,

   $VDP031.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         75000001) ,

   $VDP032.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         77500001) ,

   $VDP033.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         80000001) ,

   $VDP034.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         82500001) ,

   $VDP035.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         85000001) ,

   $VDP036.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         87500001) ,

   $VDP037.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         90000001) ,

   $VDP038.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         92500001) ,

   $VDP039.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         95000001) ,

   $VDP040.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         97500001) ,

   $VDP041.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        100000001) ,

   $VDP042.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        102500001) ,

   $VDP043.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        105000001) ,

   $VDP044.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        107500001) ,

   $VDP045.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        110000001) ,

   $VDP046.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        112500001) ,

   $VDP047.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        115000001) ,

   $VDP048.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        117500001) ,

   $VDP049.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        120000001) ,

   $VDP050.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        122500001) ,

   $VDP051.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        125000001) ,

   $VDP052.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        127500001) ,

   $VDP053.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        130000001) ,

   $VDP054.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        132500001) ,

   $VDP055.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        135000001) ,

   $VDP056.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        137500001) ,

   $VDP057.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        140000001) ,

   $VDP058.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        142500001) ,

   $VDP059.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        145000001) ,

   $VDP060.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        147500001) ,

   $VDP061.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        150000001) ,

   $VDP062.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        152500001) ,

   $VDP063.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        155000001) ,

   $VDP064.$$NSK_SUBVOL$$.LINEITEM
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        157500001) )

buffered audit;
#ifMP

?section lx2
-----------------------------------------------
-- Create part key index on line item table. --
-----------------------------------------------
#ifMX
Create index lx2 on lineitem
(
     l_partkey 
   , l_suppkey 
   , l_quantity 
   , l_extendedprice 
   , l_discount 
)
location $$partition2$$
partition( 
add first key          277778     location    $$partition2$$ ,
add first key          555555     location    $$partition1$$,
add first key          833332     location    $$partition1$$,
add first key         1111109     location    $$partition2$$ ,
add first key         1388886     location    $$partition2$$ ,
add first key         1666663     location    $$partition1$$,
add first key         1944440     location    $$partition1$$,
add first key         2222217     location    $$partition2$$ ,
add first key         2499994     location    $$partition2$$ ,
add first key         2777771     location    $$partition1$$,
add first key         3055548     location    $$partition1$$,
add first key         3333325     location    $$partition2$$ ,
add first key         3611102     location    $$partition2$$ ,
add first key         3888879     location    $$partition1$$,
add first key         4166656     location    $$partition1$$,
add first key         4444433     location    $$partition2$$ ,
add first key         4722210     location    $$partition2$$ ,
add first key         4999987     location    $$partition1$$,
add first key         5277764     location    $$partition1$$,
add first key         5555541     location    $$partition2$$ ,
add first key         5833318     location    $$partition2$$ ,
add first key         6111095     location    $$partition1$$,
add first key         6388872     location    $$partition1$$,
add first key         6666649     location    $$partition2$$ ,
add first key         6944426     location    $$partition2$$ ,
add first key         7222203     location    $$partition1$$,
add first key         7499980     location    $$partition1$$,
add first key         7777757     location    $$partition2$$ ,
add first key         8055534     location    $$partition2$$ ,
add first key         8333311     location    $$partition1$$,
add first key         8611088     location    $$partition1$$,
add first key         8888865     location    $$partition2$$ ,
add first key         9166642     location    $$partition2$$ ,
add first key         9444419     location    $$partition1$$,
add first key         9722196     location    $$partition1$$,
add first key         9999973     location    $$partition2$$ ,
add first key        10277750     location    $$partition2$$ ,
add first key        10555527     location    $$partition1$$,
add first key        10833304     location    $$partition1$$,
add first key        11111081     location    $$partition2$$ ,
add first key        11388858     location    $$partition2$$ ,
add first key        11666635     location    $$partition1$$,
add first key        11944412     location    $$partition1$$,
add first key        12222189     location    $$partition2$$ ,
add first key        12499966     location    $$partition2$$ ,
add first key        12777743     location    $$partition1$$,
add first key        13055520     location    $$partition1$$,
add first key        13333297     location    $$partition2$$ ,
add first key        13611074     location    $$partition2$$ ,
add first key        13888851     location    $$partition1$$,
add first key        14166628     location    $$partition1$$,
add first key        14444405     location    $$partition2$$ ,
add first key        14722182     location    $$partition2$$ ,
add first key        14999959     location    $$partition1$$,
add first key        15277736     location    $$partition1$$,
add first key        15555513     location    $$partition2$$ ,
add first key        15833290     location    $$partition2$$ ,
add first key        16111067     location    $$partition1$$,
add first key        16388844     location    $$partition1$$,
add first key        16666621     location    $$partition2$$ ,
add first key        16944398     location    $$partition2$$ ,
add first key        17222175     location    $$partition1$$,
add first key        17499952     location    $$partition1$$,
add first key        17777729     location    $$partition2$$ ,
add first key        18055506     location    $$partition2$$ ,
add first key        18333283     location    $$partition1$$,
add first key        18611060     location    $$partition1$$,
add first key        18888837     location    $$partition2$$ ,
add first key        19166614     location    $$partition2$$ ,
add first key        19444391     location    $$partition1$$,
add first key        19722168     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.LX2 on $$NSK_VOL$$.$$NSK_SUBVOL$$.LINEITEM
(
     l_partkey 
   , l_suppkey 
   , l_quantity 
   , l_extendedprice 
   , l_discount 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          277778      ,

  $VDP003.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          555555      ,

  $VDP004.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          833332      ,

  $VDP005.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1111109      ,

  $VDP006.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1388886      ,

  $VDP007.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1666663      ,

  $VDP008.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1944440      ,

  $VDP009.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2222217      ,

  $VDP010.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2499994      ,

  $VDP011.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         2777771      ,

  $VDP012.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3055548      ,

  $VDP013.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3333325      ,

  $VDP014.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3611102      ,

  $VDP015.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3888879      ,

  $VDP016.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4166656      ,

  $VDP017.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4444433      ,

  $VDP018.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4722210      ,

  $VDP019.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4999987      ,

  $VDP020.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         5277764      ,

  $VDP021.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5555541      ,

  $VDP022.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5833318      ,

  $VDP023.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6111095      ,

  $VDP024.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6388872      ,

  $VDP025.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6666649      ,

  $VDP026.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6944426      ,

  $VDP027.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7222203      ,

  $VDP028.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7499980      ,

  $VDP029.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         7777757      ,

  $VDP030.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8055534      ,

  $VDP031.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8333311      ,

  $VDP032.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8611088      ,

  $VDP033.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8888865      ,

  $VDP034.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9166642      ,

  $VDP035.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9444419      ,

  $VDP036.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9722196      ,

  $VDP037.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9999973      ,

  $VDP038.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        10277750      ,

  $VDP039.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10555527      ,

  $VDP040.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10833304      ,

  $VDP041.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11111081      ,

  $VDP042.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11388858      ,

  $VDP043.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11666635      ,

  $VDP044.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11944412      ,

  $VDP045.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12222189      ,

  $VDP046.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12499966      ,

  $VDP047.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        12777743      ,

  $VDP048.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13055520      ,

  $VDP049.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13333297      ,

  $VDP050.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13611074      ,

  $VDP051.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13888851      ,

  $VDP052.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14166628      ,

  $VDP053.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14444405      ,

  $VDP054.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14722182      ,

  $VDP055.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14999959      ,

  $VDP056.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        15277736      ,

  $VDP057.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15555513      ,

  $VDP058.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15833290      ,

  $VDP059.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16111067      ,

  $VDP060.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16388844      ,

  $VDP061.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16666621      ,

  $VDP062.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16944398      ,

  $VDP063.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17222175      ,

  $VDP064.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17499952      ,

  $VDP065.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        17777729      ,

  $VDP066.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18055506      ,

  $VDP067.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18333283      ,

  $VDP068.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18611060      ,

  $VDP069.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18888837      ,

  $VDP070.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        19166614      ,

  $VDP071.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19444391      ,

  $VDP072.$$NSK_SUBVOL$$.LX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19722168      

)
buffered; 
#ifMP

?section lx3
---------------------------------------------------
-- Create tax/quantity index on line item table. --
---------------------------------------------------
#ifMX
Create index lx3 on lineitem
(
     l_tax 
   , l_quantity 
   , l_shipdate 
   , l_shipmode 
   , l_extendedprice 
   , l_discount 
   , l_returnflag 
   , l_linestatus 
   , l_suppkey 
   , l_partkey
   )
location $$partition2$$
partition( 
add first key (    0.00,     7.00, DATE '1994-02-13', 'TRUCK     ') location  $$partition2$$, 
add first key (    0.00,    13.00, DATE '1996-11-11', 'TRUCK     ') location  $$partition1$$, 
add first key (    0.00,    20.00, DATE '1992-05-25', 'MAIL      ') location  $$partition1$$, 
add first key (    0.00,    26.00, DATE '1993-04-23', 'MAIL      ') location  $$partition2$$, 
add first key (    0.00,    32.00, DATE '1994-12-08', 'SHIP      ') location  $$partition2$$, 
add first key (    0.00,    38.00, DATE '1996-04-17', 'AIR       ') location  $$partition1$$, 
add first key (    0.00,    45.00, DATE '1992-04-03', 'AIR       ') location  $$partition1$$, 
add first key (    0.01,     1.00, DATE '1994-04-06', 'SHIP      ') location  $$partition2$$, 
add first key (    0.01,     7.00, DATE '1996-07-01', 'RAIL      ') location  $$partition2$$, 
add first key (    0.01,    13.00, DATE '1998-01-01', 'FOB       ') location  $$partition1$$, 
add first key (    0.01,    20.00, DATE '1993-01-04', 'MAIL      ') location  $$partition1$$, 
add first key (    0.01,    26.00, DATE '1995-06-07', 'FOB       ') location  $$partition2$$, 
add first key (    0.01,    32.00, DATE '1998-02-06', 'REG AIR   ') location  $$partition2$$, 
add first key (    0.01,    39.00, DATE '1992-11-21', 'AIR       ') location  $$partition1$$, 
add first key (    0.01,    45.00, DATE '1994-09-04', 'RAIL      ') location  $$partition1$$, 
add first key (    0.02,     1.00, DATE '1996-03-09', 'SHIP      ') location  $$partition2$$, 
add first key (    0.02,     7.00, DATE '1998-10-20', 'TRUCK     ') location  $$partition2$$, 
add first key (    0.02,    14.00, DATE '1993-11-22', 'FOB       ') location  $$partition1$$, 
add first key (    0.02,    20.00, DATE '1995-05-09', 'MAIL      ') location  $$partition1$$, 
add first key (    0.02,    26.00, DATE '1996-10-04', 'AIR       ') location  $$partition2$$, 
add first key (    0.02,    32.00, DATE '1997-11-27', 'RAIL      ') location  $$partition2$$, 
add first key (    0.02,    39.00, DATE '1992-10-31', 'RAIL      ') location  $$partition1$$, 
add first key (    0.02,    45.00, DATE '1994-07-03', 'RAIL      ') location  $$partition1$$, 
add first key (    0.03,     1.00, DATE '1996-01-30', 'AIR       ') location  $$partition2$$,  
add first key (    0.03,     7.00, DATE '1998-01-13', 'RAIL      ') location  $$partition2$$,  
add first key (    0.03,    14.00, DATE '1994-01-24', 'RAIL      ') location  $$partition1$$,  
add first key (    0.03,    20.00, DATE '1995-12-15', 'FOB       ') location  $$partition1$$,  
add first key (    0.03,    26.00, DATE '1997-02-04', 'AIR       ') location  $$partition2$$,  
add first key (    0.03,    32.00, DATE '1998-01-19', 'SHIP      ') location  $$partition2$$,  
add first key (    0.03,    39.00, DATE '1993-05-23', 'TRUCK     ') location  $$partition1$$,  
add first key (    0.03,    45.00, DATE '1995-02-27', 'SHIP      ') location  $$partition1$$,  
add first key (    0.04,     1.00, DATE '1996-10-04', 'MAIL      ') location  $$partition2$$,  
add first key (    0.04,     7.00, DATE '1998-05-21', 'FOB       ') location  $$partition2$$,  
add first key (    0.04,    14.00, DATE '1994-01-09', 'FOB       ') location  $$partition1$$,  
add first key (    0.04,    20.00, DATE '1994-08-13', 'SHIP      ') location  $$partition1$$,  
add first key (    0.04,    26.00, DATE '1994-12-18', 'SHIP      ') location  $$partition2$$, 
add first key (    0.04,    32.00, DATE '1996-01-06', 'AIR       ') location  $$partition2$$, 
add first key (    0.04,    38.00, DATE '1997-08-04', 'MAIL      ') location  $$partition1$$, 
add first key (    0.04,    45.00, DATE '1993-01-14', 'AIR       ') location  $$partition1$$, 
add first key (    0.05,     1.00, DATE '1994-08-03', 'TRUCK     ') location  $$partition2$$, 
add first key (    0.05,     7.00, DATE '1996-07-21', 'TRUCK     ') location  $$partition2$$, 
add first key (    0.05,    13.00, DATE '1998-02-04', 'FOB       ') location  $$partition1$$,  
add first key (    0.05,    20.00, DATE '1993-06-23', 'RAIL      ') location  $$partition1$$,  
add first key (    0.05,    26.00, DATE '1995-08-22', 'TRUCK     ') location  $$partition2$$,  
add first key (    0.05,    32.00, DATE '1996-12-02', 'TRUCK     ') location  $$partition2$$,  
add first key (    0.05,    39.00, DATE '1992-04-29', 'FOB       ') location  $$partition1$$,  
add first key (    0.05,    45.00, DATE '1994-02-10', 'FOB       ') location  $$partition1$$,  
add first key (    0.06,     1.00, DATE '1995-09-17', 'AIR       ') location  $$partition2$$,  
add first key (    0.06,     7.00, DATE '1996-12-12', 'MAIL      ') location  $$partition2$$,  
add first key (    0.06,    13.00, DATE '1998-11-19', 'REG AIR   ') location  $$partition1$$,  
add first key (    0.06,    20.00, DATE '1993-07-06', 'SHIP      ') location  $$partition1$$, 
add first key (    0.06,    26.00, DATE '1994-09-28', 'SHIP      ') location  $$partition2$$, 
add first key (    0.06,    32.00, DATE '1995-11-07', 'AIR       ') location  $$partition2$$, 
add first key (    0.06,    38.00, DATE '1997-01-23', 'FOB       ') location  $$partition1$$,  
add first key (    0.06,    44.00, DATE '1998-04-22', 'RAIL      ') location  $$partition1$$,  
add first key (    0.07,     1.00, DATE '1993-02-07', 'AIR       ') location  $$partition2$$,  
add first key (    0.07,     7.00, DATE '1994-09-30', 'MAIL      ') location  $$partition2$$,  
add first key (    0.07,    13.00, DATE '1995-12-29', 'AIR       ') location  $$partition1$$,  
add first key (    0.07,    19.00, DATE '1998-01-03', 'MAIL      ') location  $$partition1$$,
add first key (    0.07,    26.00, DATE '1993-04-19', 'REG AIR   ') location  $$partition2$$,  
add first key (    0.07,    32.00, DATE '1995-07-22', 'TRUCK     ') location  $$partition2$$,  
add first key (    0.07,    38.00, DATE '1996-10-03', 'RAIL      ') location  $$partition1$$,  
add first key (    0.07,    44.00, DATE '1998-04-22', 'MAIL      ') location  $$partition1$$,  
add first key (    0.08,     1.00, DATE '1992-08-03', 'SHIP      ') location  $$partition2$$,  
add first key (    0.08,     7.00, DATE '1994-05-17', 'RAIL      ') location  $$partition2$$, 
add first key (    0.08,    13.00, DATE '1996-03-31', 'REG AIR   ') location  $$partition1$$, 
add first key (    0.08,    19.00, DATE '1997-12-10', 'TRUCK     ') location  $$partition1$$, 
add first key (    0.08,    26.00, DATE '1993-01-26', 'FOB       ') location  $$partition2$$, 
add first key (    0.08,    32.00, DATE '1994-10-19', 'RAIL      ') location  $$partition2$$,  
add first key (    0.08,    38.00, DATE '1996-01-28', 'SHIP      ') location  $$partition1$$,  
add first key (    0.08,    44.00, DATE '1997-05-06', 'REG AIR   ') location  $$partition1$$
)
;
-- BUFFERED is not supported
-- attribute buffered;
#ifMX

#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.LX3 on $$NSK_VOL$$.$$NSK_SUBVOL$$.LINEITEM
(
     l_tax 
   , l_quantity 
   , l_shipdate 
   , l_shipmode 
   , l_extendedprice 
   , l_discount 
   , l_returnflag 
   , l_linestatus 
   , l_suppkey 
   , l_partkey
   )
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.00,     7.00, date '1994-02-13', 'truck     ') , 

  $VDP003.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.00,    13.00, date '1996-11-11', 'truck     ') , 

  $VDP004.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.00,    20.00, date '1992-05-25', 'mail      ') , 

  $VDP005.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.00,    26.00, date '1993-04-23', 'mail      ') , 

  $VDP006.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.00,    32.00, date '1994-12-08', 'ship      ') , 

  $VDP007.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.00,    38.00, date '1996-04-17', 'air       ') , 

  $VDP008.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.00,    45.00, date '1992-04-03', 'air       ') , 

  $VDP009.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.01,     1.00, date '1994-04-06', 'ship      ') , 

  $VDP010.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.01,     7.00, date '1996-07-01', 'rail      ') , 

  $VDP011.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.01,    13.00, date '1998-01-01', 'fob       ') , 

  $VDP012.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.01,    20.00, date '1993-01-04', 'mail      ') , 

  $VDP013.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.01,    26.00, date '1995-06-07', 'fob       ') , 

  $VDP014.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.01,    32.00, date '1998-02-06', 'reg air   ') , 

  $VDP015.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.01,    39.00, date '1992-11-21', 'air       ') , 

  $VDP016.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.01,    45.00, date '1994-09-04', 'rail      ') , 

  $VDP017.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.02,     1.00, date '1996-03-09', 'ship      ') , 

  $VDP018.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.02,     7.00, date '1998-10-20', 'truck     ') , 

  $VDP019.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.02,    14.00, date '1993-11-22', 'fob       ') , 

  $VDP020.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.02,    20.00, date '1995-05-09', 'mail      ') , 

  $VDP021.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.02,    26.00, date '1996-10-04', 'air       ') , 

  $VDP022.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.02,    32.00, date '1997-11-27', 'rail      ') , 

  $VDP023.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.02,    39.00, date '1992-10-31', 'rail      ') , 

  $VDP024.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.02,    45.00, date '1994-07-03', 'rail      ') , 

  $VDP025.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.03,     1.00, date '1996-01-30', 'air       ') ,  

  $VDP026.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.03,     7.00, date '1998-01-13', 'rail      ') ,  

  $VDP027.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.03,    14.00, date '1994-01-24', 'rail      ') ,  

  $VDP028.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.03,    20.00, date '1995-12-15', 'fob       ') ,  

  $VDP029.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.03,    26.00, date '1997-02-04', 'air       ') ,  

  $VDP030.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.03,    32.00, date '1998-01-19', 'ship      ') ,  

  $VDP031.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.03,    39.00, date '1993-05-23', 'truck     ') ,  

  $VDP032.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.03,    45.00, date '1995-02-27', 'ship      ') ,  

  $VDP033.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.04,     1.00, date '1996-10-04', 'mail      ') ,  

  $VDP034.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.04,     7.00, date '1998-05-21', 'fob       ') ,  

  $VDP035.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.04,    14.00, date '1994-01-09', 'fob       ') ,  

  $VDP036.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.04,    20.00, date '1994-08-13', 'ship      ') ,  

  $VDP037.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.04,    26.00, date '1994-12-18', 'ship      ') , 

  $VDP038.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.04,    32.00, date '1996-01-06', 'air       ') , 

  $VDP039.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.04,    38.00, date '1997-08-04', 'mail      ') , 

  $VDP040.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.04,    45.00, date '1993-01-14', 'air       ') , 

  $VDP041.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.05,     1.00, date '1994-08-03', 'truck     ') , 

  $VDP042.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.05,     7.00, date '1996-07-21', 'truck     ') , 

  $VDP043.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.05,    13.00, date '1998-02-04', 'fob       ') ,  

  $VDP044.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.05,    20.00, date '1993-06-23', 'rail      ') ,  

  $VDP045.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.05,    26.00, date '1995-08-22', 'truck     ') ,  

  $VDP046.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.05,    32.00, date '1996-12-02', 'truck     ') ,  

  $VDP047.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.05,    39.00, date '1992-04-29', 'fob       ') ,  

  $VDP048.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.05,    45.00, date '1994-02-10', 'fob       ') ,  

  $VDP049.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.06,     1.00, date '1995-09-17', 'air       ') ,  

  $VDP050.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.06,     7.00, date '1996-12-12', 'mail      ') ,  

  $VDP051.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.06,    13.00, date '1998-11-19', 'reg air   ') ,  

  $VDP052.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.06,    20.00, date '1993-07-06', 'ship      ') , 

  $VDP053.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.06,    26.00, date '1994-09-28', 'ship      ') , 

  $VDP054.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.06,    32.00, date '1995-11-07', 'air       ') , 

  $VDP055.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.06,    38.00, date '1997-01-23', 'fob       ') ,  

  $VDP056.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.06,    44.00, date '1998-04-22', 'rail      ') ,  

  $VDP057.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.07,     1.00, date '1993-02-07', 'air       ') ,  

  $VDP058.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.07,     7.00, date '1994-09-30', 'mail      ') ,  

  $VDP059.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.07,    13.00, date '1995-12-29', 'air       ') ,  

  $VDP060.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.07,    19.00, date '1998-01-03', 'mail      ') ,

  $VDP061.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.07,    26.00, date '1993-04-19', 'reg air   ') ,  

  $VDP062.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.07,    32.00, date '1995-07-22', 'truck     ') ,  

  $VDP063.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.07,    38.00, date '1996-10-03', 'rail      ') ,  

  $VDP064.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.07,    44.00, date '1998-04-22', 'mail      ') ,  

  $VDP065.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.08,     1.00, date '1992-08-03', 'ship      ') ,  

  $VDP066.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.08,     7.00, date '1994-05-17', 'rail      ') , 

  $VDP067.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.08,    13.00, date '1996-03-31', 'reg air   ') , 

  $VDP068.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.08,    19.00, date '1997-12-10', 'truck     ') , 

  $VDP069.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.08,    26.00, date '1993-01-26', 'fob       ') , 

  $VDP070.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key (    0.08,    32.00, date '1994-10-19', 'rail      ') ,  

  $VDP071.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.08,    38.00, date '1996-01-28', 'ship      ') ,  

  $VDP072.$$NSK_SUBVOL$$.LX3
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key (    0.08,    44.00, date '1997-05-06', 'reg air   ') 

)
buffered;
#ifMP

?section lx5
------------------------------------------------
-- Create ship mode index on line item table. --
------------------------------------------------
#ifMX
Create index LX5 on LINEITEM
(
     l_shipmode 
   , l_receiptdate 
   , l_shipdate 
   , l_commitdate 
)
location $$partition2$$
partition(
add first key ('AIR       ', DATE '1992-07-01')     location    $$partition2$$,
add first key ('AIR       ', DATE '1993-01-01')     location    $$partition1$$,
add first key ('AIR       ', DATE '1993-07-01')     location    $$partition1$$,
add first key ('AIR       ', DATE '1994-01-01')     location    $$partition2$$,
add first key ('AIR       ', DATE '1994-07-01')     location    $$partition2$$,
add first key ('AIR       ', DATE '1995-01-01')     location    $$partition1$$,
add first key ('AIR       ', DATE '1995-07-01')     location    $$partition1$$,
add first key ('AIR       ', DATE '1996-01-01')     location    $$partition2$$,
add first key ('AIR       ', DATE '1996-07-01')     location    $$partition2$$,
add first key ('AIR       ', DATE '1997-01-01')     location    $$partition1$$,
add first key ('AIR       ', DATE '1997-07-01')     location    $$partition1$$,
add first key ('AIR       ', DATE '1998-01-01')     location    $$partition2$$,
add first key ('AIR       ', DATE '1998-07-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1992-01-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1992-07-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1993-01-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1993-07-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1994-01-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1994-07-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1995-01-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1995-07-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1996-01-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1996-07-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1997-01-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1997-07-01')     location    $$partition2$$,
add first key ('FOB       ', DATE '1998-01-01')     location    $$partition1$$,
add first key ('FOB       ', DATE '1998-07-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1992-01-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1992-07-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1993-01-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1993-07-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1994-01-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1994-07-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1995-01-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1995-07-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1996-01-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1996-07-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1997-01-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1997-07-01')     location    $$partition1$$,
add first key ('MAIL      ', DATE '1998-01-01')     location    $$partition2$$,
add first key ('MAIL      ', DATE '1998-07-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1992-01-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1992-07-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1993-01-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1993-07-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1994-01-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1994-07-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1995-01-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1995-07-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1996-01-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1996-07-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1997-01-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1997-07-01')     location    $$partition2$$,
add first key ('RAIL      ', DATE '1998-01-01')     location    $$partition1$$,
add first key ('RAIL      ', DATE '1998-07-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1992-01-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1992-07-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1993-01-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1993-07-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1994-01-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1994-07-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1995-01-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1995-07-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1996-01-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1996-07-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1997-01-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1997-07-01')     location    $$partition1$$,
add first key ('REG AIR   ', DATE '1998-01-01')     location    $$partition2$$,
add first key ('REG AIR   ', DATE '1998-07-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1992-01-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1992-07-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1993-01-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1993-07-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1994-01-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1994-07-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1995-01-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1995-07-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1996-01-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1996-07-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1997-01-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1997-07-01')     location    $$partition2$$,
add first key ('SHIP      ', DATE '1998-01-01')     location    $$partition1$$,
add first key ('SHIP      ', DATE '1998-07-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1992-01-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1992-07-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1993-01-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1993-07-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1994-01-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1994-07-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1995-01-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1995-07-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1996-01-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1996-07-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1997-01-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1997-07-01')     location    $$partition1$$,
add first key ('TRUCK     ', DATE '1998-01-01')     location    $$partition2$$,
add first key ('TRUCK     ', DATE '1998-07-01')     location    $$partition2$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.LX5 on $$NSK_VOL$$.$$NSK_SUBVOL$$.LINEITEM
(
     l_shipmode 
   , l_receiptdate 
   , l_shipdate 
   , l_commitdate 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition(
  $VDP002.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1992-07-01')     ,

  $VDP003.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('air       ', date '1993-01-01')     ,

  $VDP004.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('air       ', date '1993-07-01')     ,

  $VDP005.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1994-01-01')     ,

  $VDP006.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1994-07-01')     ,

  $VDP007.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('air       ', date '1995-01-01')     ,

  $VDP008.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('air       ', date '1995-07-01')     ,

  $VDP009.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1996-01-01')     ,

  $VDP010.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1996-07-01')     ,

  $VDP011.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('air       ', date '1997-01-01')     ,

  $VDP012.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('air       ', date '1997-07-01')     ,

  $VDP013.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1998-01-01')     ,

  $VDP014.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('air       ', date '1998-07-01')     ,

  $VDP015.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1992-01-01')     ,

  $VDP016.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1992-07-01')     ,

  $VDP017.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('fob       ', date '1993-01-01')     ,

  $VDP018.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('fob       ', date '1993-07-01')     ,

  $VDP019.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1994-01-01')     ,

  $VDP020.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1994-07-01')     ,

  $VDP021.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('fob       ', date '1995-01-01')     ,

  $VDP022.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('fob       ', date '1995-07-01')     ,

  $VDP023.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1996-01-01')     ,

  $VDP024.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1996-07-01')     ,

  $VDP025.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('fob       ', date '1997-01-01')     ,

  $VDP026.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('fob       ', date '1997-07-01')     ,

  $VDP027.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1998-01-01')     ,

  $VDP028.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('fob       ', date '1998-07-01')     ,

  $VDP029.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1992-01-01')     ,

  $VDP030.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1992-07-01')     ,

  $VDP031.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('mail      ', date '1993-01-01')     ,

  $VDP032.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('mail      ', date '1993-07-01')     ,

  $VDP033.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1994-01-01')     ,

  $VDP034.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1994-07-01')     ,

  $VDP035.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('mail      ', date '1995-01-01')     ,

  $VDP036.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('mail      ', date '1995-07-01')     ,

  $VDP037.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1996-01-01')     ,

  $VDP038.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1996-07-01')     ,

  $VDP039.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('mail      ', date '1997-01-01')     ,

  $VDP040.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('mail      ', date '1997-07-01')     ,

  $VDP041.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1998-01-01')     ,

  $VDP042.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('mail      ', date '1998-07-01')     ,

  $VDP043.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1992-01-01')     ,

  $VDP044.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1992-07-01')     ,

  $VDP045.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('rail      ', date '1993-01-01')     ,

  $VDP046.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('rail      ', date '1993-07-01')     ,

  $VDP047.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1994-01-01')     ,

  $VDP048.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1994-07-01')     ,

  $VDP049.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('rail      ', date '1995-01-01')     ,

  $VDP050.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('rail      ', date '1995-07-01')     ,

  $VDP051.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1996-01-01')     ,

  $VDP052.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1996-07-01')     ,

  $VDP053.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('rail      ', date '1997-01-01')     ,

  $VDP054.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('rail      ', date '1997-07-01')     ,

  $VDP055.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1998-01-01')     ,

  $VDP056.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('rail      ', date '1998-07-01')     ,

  $VDP057.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1992-01-01')     ,

  $VDP058.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1992-07-01')     ,

  $VDP059.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('reg air   ', date '1993-01-01')     ,

  $VDP060.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('reg air   ', date '1993-07-01')     ,

  $VDP061.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1994-01-01')     ,

  $VDP062.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1994-07-01')     ,

  $VDP063.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('reg air   ', date '1995-01-01')     ,

  $VDP064.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('reg air   ', date '1995-07-01')     ,

  $VDP065.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1996-01-01')     ,

  $VDP066.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1996-07-01')     ,

  $VDP067.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('reg air   ', date '1997-01-01')     ,

  $VDP068.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('reg air   ', date '1997-07-01')     ,

  $VDP069.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1998-01-01')     ,

  $VDP070.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('reg air   ', date '1998-07-01')     ,

  $VDP071.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1992-01-01')     ,

  $VDP072.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1992-07-01')     ,

  $VDP073.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('ship      ', date '1993-01-01')     ,

  $VDP074.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('ship      ', date '1993-07-01')     ,

  $VDP075.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1994-01-01')     ,

  $VDP076.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1994-07-01')     ,

  $VDP077.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('ship      ', date '1995-01-01')     ,

  $VDP078.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('ship      ', date '1995-07-01')     ,

  $VDP079.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1996-01-01')     ,

  $VDP080.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1996-07-01')     ,

  $VDP081.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('ship      ', date '1997-01-01')     ,

  $VDP082.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('ship      ', date '1997-07-01')     ,

  $VDP083.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1998-01-01')     ,

  $VDP084.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('ship      ', date '1998-07-01')     ,

  $VDP085.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1992-01-01')     ,

  $VDP086.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1992-07-01')     ,

  $VDP087.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('truck     ', date '1993-01-01')     ,

  $VDP088.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('truck     ', date '1993-07-01')     ,

  $VDP089.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1994-01-01')     ,

  $VDP090.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1994-07-01')     ,

  $VDP091.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('truck     ', date '1995-01-01')     ,

  $VDP092.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('truck     ', date '1995-07-01')     ,

  $VDP093.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1996-01-01')     ,

  $VDP094.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1996-07-01')     ,

  $VDP095.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('truck     ', date '1997-01-01')     ,

  $VDP096.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('truck     ', date '1997-07-01')     ,

  $VDP097.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1998-01-01')     ,

  $VDP098.$$NSK_SUBVOL$$.LX5
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('truck     ', date '1998-07-01')      

)
buffered; 
#ifMP

?section nation
--------------------------
-- Create nation table. --
--------------------------
#ifMX
Create table nation  (
   n_nationkey         int                not null not droppable, 
   n_name              char(25)           not null not droppable, 
   n_regionkey         int                not null not droppable, 
   n_comment           varchar(152)       not null not droppable, 
primary key (n_nationkey)  not droppable) 
store by primary key
location $$partition2$$ 
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.NATION (
   n_nationkey         int                not null,
   n_name              char(25)           not null,
   n_regionkey         int                not null,
   n_comment           varchar(152)       not null,
primary key (n_nationkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
buffered audit;
#ifMP

--------------------------------------------------------------
--  Since nation table is so small, insert its records now. --
--------------------------------------------------------------
prepare insertNation from
insert into NATION values(?a, ?b, ?c, ?d);

BEGIN WORK;
set param ?a 0;
set param ?b 'ALGERIA';
set param ?c 0;
set param ?d '2Cxhl7 L1iwk6hMh300izngN32CPwCikyLk6khMzSRA';
execute insertNation;
set param ?a 1;
set param ?b 'ARGENTINA';
set param ?c 1;
set param ?d 'zQn3Okwz1wLn7PLS3OhCgn56kP5PyRikgi1B7lL';
execute insertNation;
set param ?a 2;
set param ?b 'BRAZIL';
set param ?c 1;
set param ?d 'gLmS0nACAmnBCj2klki7RCPNgPxnCOjNg4k OiAg57COSOm1NwCnOyLx40R SC y20gPPAkNk5hxRhR5OmgS1iPQQzNAxPL30n67OgyC l617Sh4LS';
execute insertNation;
set param ?a 3;
set param ?b 'CANADA';
set param ?c 1;
set param ?d ' 4yMO AhnQ5Lh wzQAM662Aw1ByCl7CxmzRwNR5nAlO4 x';
execute insertNation;
set param ?a 4;
set param ?b 'EGYPT';
set param ?c 4;
set param ?d 'l1im5126  Cxj NMQmLxOikni02j2m3Ah4yNR1QQiL507j2QSlyN';
execute insertNation;
set param ?a 5;
set param ?b 'ETHIOPIA';
set param ?c 0;
set param ?d 'NS7n LSOP Oz5n1AlB2S02nN0lMh4SBxP iRhBO 047R26 2BlM';
execute insertNation;
set param ?a 6;
set param ?b 'FRANCE';
set param ?c 3;
set param ?d '3mjmizl S 3L3k2hNNhNlP4w370xRxyN15wn';
execute insertNation;
set param ?a 7;
set param ?b 'GERMANY';
set param ?c 3;
set param ?d 'z nOP4RkwO CmzBB 516mAg lByw4OM3QyNPA';
execute insertNation;
set param ?a 8;
set param ?b 'INDIA';
set param ?c 2;
set param ?d 'MNlR5RCiRMj1l11wjN7Myn M1lylNlMmBQl7PL4C  kkxQkgPQ7i3w6B67R2QkOO40xl4Q2iw76jRL7ilhR5Q 0xC7RRm5iQ2NAx2LiBm3QiO27j';
execute insertNation;
set param ?a 9;
set param ?b 'INDONESIA';
set param ?c 2;
set param ?d 'SjPmQO71Lj 7ABj6MxlAQk3nLwi73BPxzCwjzMn4zlLzgg6nnz0j0w zxC66gP6ykRPMg';
execute insertNation;
set param ?a 10;
set param ?b 'IRAN';
set param ?c 4;
set param ?d 'h532g43BgShyO50OgSB2hO6jxQn3Q1w4NmPL4hg0mmPOC5SSLg6miR7m6B317 lz4jQMwPRyRn1jiRPmi mk0 yj0C5M5xi';
execute insertNation;
set param ?a 11;
set param ?b 'IRAQ';
set param ?c 4;
set param ?d '6N gw7Mg4xPiAwjQS6iROwPgjz7jkPll5RkRxgCClzQinjMkOx3PyxOyzyN6nL3BzlyNM0OwxOwxBLO0lkkRMyBO';
execute insertNation;
set param ?a 12;
set param ?b 'JAPAN';
set param ?c 2;
set param ?d 'y PiRn6O4Rny0P6Q0NhM5N26AhghiClRQlP QNQx205B3im7zPBOSSm5MAl3BjMLiM3P';
execute insertNation;
set param ?a 13;
set param ?b 'JORDAN';
set param ?c 4;
set param ?d 'P53ljBPS 2PM7g6MwwywM47mCji1QkB4RNghzxB56mC5QiwOn2QlM3ikz6wN5NlM4N7C7B';
execute insertNation;
set param ?a 14;
set param ?b 'KENYA';
set param ?c 0;
set param ?d 'yA0jNSxmS25NRiCy1B6yhSL4NLMROQ3kLyAPx43wil27kN1QmPLmPw7ywh2kyj2iSBwSjx26zClx';
execute insertNation;
set param ?a 15;
set param ?b 'MOROCCO';
set param ?c 0;
set param ?d '7mC2hnARnj21nwllAOhR2nwRmgz22AkP6xj3iQiPNB0PjxBMzS3g 4y0L4Alx1gNCAP2kjQMBR2xwiiSNLgCMQx74RmhMy4OONhPCNQQ 3y';
execute insertNation;
set param ?a 16;
set param ?b 'MOZAMBIQUE';
set param ?c 0;
set param ?d 'LB6SkSOmkznRLS4z5P2BOmC23RnA6h7mn0gPAAN7nkxy6jO0k3w3R32R6A1ASk0LMyngO36jCL1gl5wQw4AMPC';
execute insertNation;
set param ?a 17;
set param ?b 'PERU';
set param ?c 1;
set param ?d '35h63 yS7gjRh22iyBlhy5wjLMQnln74k0j5O ygx1miQgA66hyhP3740PQOgRkwhy1i3LSwzjB 3yjh0QnyMMN A7Qn 6NOC2jg65QRLAgS';
execute insertNation;
set param ?a 18;
set param ?b 'CHINA';
set param ?c 2;
set param ?d '2hg1nh2OCS1nzh2mmAkP w4hyPg2SLxlAO4g0mCCjxBhBnwMi52M575SPzO07ggjN32B5SyhNOR0Ah4C1Qz 3P';
execute insertNation;
set param ?a 19;
set param ?b 'ROMANIA';
set param ?c 3;
set param ?d 'n7l0B41Qw5 mmS0QmQ3wNRPL62kiQg0RmQ6C4QR67iyzw0Mz5yMBLwSlP0lP7x4S7OR637nj1jig  giN11wm265';
execute insertNation;
set param ?a 20;
set param ?b 'SAUDI ARABIA';
set param ?c 4;
set param ?d 'kC7 nNNz3ON73Az03O  S13CklRh47jlxw5 5k6LClx52LQCQS6P1B3k1xPgMnk3PmMy7 l1nlBBBwBk0x6MACxOiigLO5mm5mO7N';
execute insertNation;
set param ?a 21;
set param ?b 'VIETNAM';
set param ?c 2;
set param ?d 'wzw7lPgRmnCM5i2x7zy1hO0P75Pwk5z4Sl627l7LlN';
execute insertNation;
set param ?a 22;
set param ?b 'RUSSIA';
set param ?c 3;
set param ?d '63w6MRN 2yANOMC0hjAn4RC7Qy6jhln37 2RggAM3x5S3i1On57';
execute insertNation;
set param ?a 23;
set param ?b 'UNITED KINGDOM';
set param ?c 3;
set param ?d 'POnSl70NBLPgh2B04P3m4j3lO0R2525Q7BCSBgwAQ712w0RAPxhMkkjhQCORLQihjCBO3gSiN5gx4mjnLiCx6w2MzR jwgLwP7kRxw4';
execute insertNation;
set param ?a 24;
set param ?b 'UNITED STATES';
set param ?c 1;
set param ?d 'QQ41AxzBSQACRA1wCLyONCi5yzCyljQR144lnNLm2 Q7PRyk BRzP ';
execute insertNation;
COMMIT WORK;

?section orders
--------------------------
-- Create orders table. --
--------------------------
#ifMX
Create table orders  (
   o_orderkey          int                not null not droppable, 
   o_custkey           int                not null not droppable, 
   o_orderstatus       char(1)            not null not droppable, 
   o_totalprice        numeric(12,2)      not null not droppable, 
   o_orderdate         date               not null not droppable, 
   o_orderpriority     char(15)           not null not droppable, 
   o_clerk             char(15)           not null not droppable, 
   o_shippriority      int                not null not droppable, 
   o_comment           varchar(79)        not null not droppable, 
primary key (o_orderkey)  not droppable) 
store by primary key
location $$partition2$$
partition (
   add first key (          2500001) location $$partition1$$,
   add first key (          5000001) location $$partition2$$,
   add first key (          7500001) location $$partition2$$,
   add first key (         10000001) location $$partition1$$,
   add first key (         12500001) location $$partition1$$,
   add first key (         15000001) location $$partition2$$,
   add first key (         17500001) location $$partition2$$,
   add first key (         20000001) location $$partition1$$,
   add first key (         22500001) location $$partition1$$,
   add first key (         25000001) location $$partition2$$,
   add first key (         27500001) location $$partition2$$,
   add first key (         30000001) location $$partition1$$,
   add first key (         32500001) location $$partition1$$,
   add first key (         35000001) location $$partition2$$,
   add first key (         37500001) location $$partition1$$,
   add first key (         40000001) location $$partition2$$,
   add first key (         42500001) location $$partition2$$,
   add first key (         45000001) location $$partition1$$,
   add first key (         47500001) location $$partition1$$,
   add first key (         50000001) location $$partition2$$,
   add first key (         52500001) location $$partition2$$,
   add first key (         55000001) location $$partition1$$,
   add first key (         57500001) location $$partition1$$,
   add first key (         60000001) location $$partition2$$,
   add first key (         62500001) location $$partition2$$,
   add first key (         65000001) location $$partition1$$,
   add first key (         67500001) location $$partition1$$,
   add first key (         70000001) location $$partition2$$,
   add first key (         72500001) location $$partition1$$,
   add first key (         75000001) location $$partition1$$,
   add first key (         77500001) location $$partition2$$,
   add first key (         80000001) location $$partition2$$,
   add first key (         82500001) location $$partition1$$,
   add first key (         85000001) location $$partition1$$,
   add first key (         87500001) location $$partition2$$,
   add first key (         90000001) location $$partition2$$,
   add first key (         92500001) location $$partition1$$,
   add first key (         95000001) location $$partition1$$,
   add first key (         97500001) location $$partition2$$,
   add first key (        100000001) location $$partition1$$,
   add first key (        102500001) location $$partition2$$,
   add first key (        105000001) location $$partition2$$,
   add first key (        107500001) location $$partition1$$,
   add first key (        110000001) location $$partition1$$,
   add first key (        112500001) location $$partition1$$,
   add first key (        115000001) location $$partition1$$,
   add first key (        117500001) location $$partition2$$,
   add first key (        120000001) location $$partition2$$,
   add first key (        122500001) location $$partition1$$,
   add first key (        125000001) location $$partition1$$,
   add first key (        127500001) location $$partition2$$,
   add first key (        130000001) location $$partition2$$,
   add first key (        132500001) location $$partition1$$,
   add first key (        135000001) location $$partition1$$,
   add first key (        137500001) location $$partition2$$,
   add first key (        140000001) location $$partition1$$,
   add first key (        142500001) location $$partition2$$,
   add first key (        145000001) location $$partition2$$,
   add first key (        147500001) location $$partition1$$,
   add first key (        150000001) location $$partition1$$,
   add first key (        152500001) location $$partition1$$,
   add first key (        155000001) location $$partition2$$,
   add first key (        157500001) location $$partition2$$)
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.ORDERS (
   o_orderkey          int                not null,
   o_custkey           int                not null,
   o_orderstatus       char(1)            not null,
   o_totalprice        numeric(12,2)      not null,
   o_orderdate         date               not null,
   o_orderpriority     char(15)           not null,
   o_clerk             char(15)           not null,
   o_shippriority      int                not null,
   o_comment           varchar(79)        not null,
primary key (o_orderkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition (
   $VDP002.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (          2500001) ,

   $VDP003.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (          5000001) ,

   $VDP004.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (          7500001) ,

   $VDP005.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         10000001) ,

   $VDP006.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         12500001) ,

   $VDP007.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         15000001) ,

   $VDP008.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         17500001) ,

   $VDP009.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         20000001) ,

   $VDP010.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         22500001) ,

   $VDP011.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         25000001) ,

   $VDP012.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         27500001) ,

   $VDP013.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         30000001) ,

   $VDP014.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         32500001) ,

   $VDP015.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         35000001) ,

   $VDP016.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         37500001) ,

   $VDP017.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         40000001) ,

   $VDP018.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         42500001) ,

   $VDP019.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         45000001) ,

   $VDP020.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         47500001) ,

   $VDP021.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         50000001) ,

   $VDP022.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         52500001) ,

   $VDP023.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         55000001) ,

   $VDP024.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         57500001) ,

   $VDP025.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         60000001) ,

   $VDP026.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         62500001) ,

   $VDP027.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         65000001) ,

   $VDP028.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         67500001) ,

   $VDP029.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         70000001) ,

   $VDP030.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         72500001) ,

   $VDP031.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         75000001) ,

   $VDP032.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         77500001) ,

   $VDP033.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         80000001) ,

   $VDP034.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         82500001) ,

   $VDP035.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         85000001) ,

   $VDP036.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         87500001) ,

   $VDP037.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         90000001) ,

   $VDP038.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         92500001) ,

   $VDP039.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         95000001) ,

   $VDP040.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         97500001) ,

   $VDP041.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        100000001) ,

   $VDP042.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        102500001) ,

   $VDP043.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        105000001) ,

   $VDP044.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        107500001) ,

   $VDP045.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        110000001) ,

   $VDP046.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        112500001) ,

   $VDP047.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        115000001) ,

   $VDP048.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        117500001) ,

   $VDP049.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        120000001) ,

   $VDP050.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        122500001) ,

   $VDP051.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        125000001) ,

   $VDP052.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        127500001) ,

   $VDP053.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        130000001) ,

   $VDP054.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        132500001) ,

   $VDP055.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        135000001) ,

   $VDP056.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        137500001) ,

   $VDP057.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        140000001) ,

   $VDP058.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        142500001) ,

   $VDP059.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        145000001) ,

   $VDP060.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        147500001) ,

   $VDP061.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        150000001) ,

   $VDP062.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        152500001) ,

   $VDP063.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        155000001) ,

   $VDP064.$$NSK_SUBVOL$$.ORDERS
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        157500001) )

buffered audit;
#ifMP

?section ox1
-----------------------------------------
--  Create clerk index on order table. --
-----------------------------------------
#ifMX
Create index ox1 on orders
(
     o_clerk
   , o_orderdate 
)

location $$partition2$$
partition( 
add first key     'Clerk#000006250'   location    $$partition2$$,
add first key     'Clerk#000012500'   location    $$partition1$$,
add first key     'Clerk#000018750'   location    $$partition1$$,
add first key     'Clerk#000025000'   location    $$partition2$$,
add first key     'Clerk#000031250'   location    $$partition2$$,
add first key     'Clerk#000037500'   location    $$partition1$$,
add first key     'Clerk#000043750'   location    $$partition1$$,
add first key     'Clerk#000050000'   location    $$partition2$$,
add first key     'Clerk#000056250'   location    $$partition2$$,
add first key     'Clerk#000062500'   location    $$partition1$$,
add first key     'Clerk#000068750'   location    $$partition1$$,
add first key     'Clerk#000075000'   location    $$partition2$$,
add first key     'Clerk#000081250'   location    $$partition2$$,
add first key     'Clerk#000087500'   location    $$partition1$$,
add first key     'Clerk#000093750'   location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.OX1 on $$NSK_VOL$$.$$NSK_SUBVOL$$.ORDERS
(
     o_clerk
   , o_orderdate 
)

catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000006250'   ,

  $VDP003.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000012500'   ,

  $VDP004.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000018750'   ,

  $VDP005.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000025000'   ,

  $VDP006.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000031250'   ,

  $VDP007.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000037500'   ,

  $VDP008.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000043750'   ,

  $VDP009.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000050000'   ,

  $VDP010.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000056250'   ,

  $VDP011.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000062500'   ,

  $VDP012.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000068750'   ,

  $VDP013.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000075000'   ,

  $VDP014.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key     'clerk#000081250'   ,

  $VDP015.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000087500'   ,

  $VDP016.$$NSK_SUBVOL$$.OX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key     'clerk#000093750'    

)
buffered; 
#ifMP

?section ox2
------------------------------------------------
--  Create customer key index on order table. --
------------------------------------------------
#ifMX
Create index ox2 on orders
(
     o_custkey 
   , o_orderdate 
   , o_shippriority 
)
location $$partition2$$
partition( 
   add first key (         234001) location $$partition1$$,
   add first key (         468001) location $$partition2$$,
   add first key (         702001) location $$partition2$$,
   add first key (         936001) location $$partition1$$,
   add first key (        1170001) location $$partition1$$,
   add first key (        1404001) location $$partition2$$,
   add first key (        1638001) location $$partition2$$,
   add first key (        1872001) location $$partition1$$,
   add first key (        2106001) location $$partition1$$,
   add first key (        2340001) location $$partition2$$,
   add first key (        2574001) location $$partition2$$,
   add first key (        2808001) location $$partition1$$,
   add first key (        3042001) location $$partition1$$,
   add first key (        3276001) location $$partition2$$,
   add first key (        3510001) location $$partition1$$,
   add first key (        3744001) location $$partition2$$,
   add first key (        3978001) location $$partition2$$,
   add first key (        4212001) location $$partition1$$,
   add first key (        4446001) location $$partition1$$,
   add first key (        4680001) location $$partition2$$,
   add first key (        4914001) location $$partition2$$,
   add first key (        5148001) location $$partition1$$,
   add first key (        5382001) location $$partition1$$,
   add first key (        5616001) location $$partition2$$,
   add first key (        5850001) location $$partition2$$,
   add first key (        6084001) location $$partition1$$,
   add first key (        6318001) location $$partition1$$,
   add first key (        6552001) location $$partition2$$,
   add first key (        6786001) location $$partition1$$,
   add first key (        7020001) location $$partition2$$,
   add first key (        7254001) location $$partition2$$,
   add first key (        7488001) location $$partition1$$,
   add first key (        7722001) location $$partition2$$,
   add first key (        7956001) location $$partition2$$,
   add first key (        8190001) location $$partition1$$,
   add first key (        8424001) location $$partition1$$,
   add first key (        8658001) location $$partition2$$,
   add first key (        8892001) location $$partition2$$,
   add first key (        9126001) location $$partition1$$,
   add first key (        9360001) location $$partition1$$,
   add first key (        9594001) location $$partition2$$,
   add first key (        9828001) location $$partition2$$,
   add first key (       10062001) location $$partition1$$,
   add first key (       10296001) location $$partition1$$,
   add first key (       10530001) location $$partition2$$,
   add first key (       10764001) location $$partition1$$,
   add first key (       10998001) location $$partition2$$,
   add first key (       11232001) location $$partition2$$,
   add first key (       11466001) location $$partition1$$,
   add first key (       11700001) location $$partition1$$,
   add first key (       11934001) location $$partition2$$,
   add first key (       12168001) location $$partition2$$,
   add first key (       12402001) location $$partition1$$,
   add first key (       12636001) location $$partition1$$,
   add first key (       12870001) location $$partition2$$,
   add first key (       13104001) location $$partition2$$,
   add first key (       13338001) location $$partition1$$,
   add first key (       13572001) location $$partition1$$,
   add first key (       13806001) location $$partition2$$,
   add first key (       14040001) location $$partition1$$,
   add first key (       14274001) location $$partition2$$,
   add first key (       14508001) location $$partition2$$,
   add first key (       14742001) location $$partition1$$)
;
-- BUFFERED is not supported
-- attribute buffered;

#ifMX


#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.OX2 on $$NSK_VOL$$.$$NSK_SUBVOL$$.ORDERS
(
     o_custkey 
   , o_orderdate 
   , o_shippriority 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
   $VDP002.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         234001) ,

   $VDP003.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         468001) ,

   $VDP004.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (         702001) ,

   $VDP005.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (         936001) ,

   $VDP006.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        1170001) ,

   $VDP007.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        1404001) ,

   $VDP008.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        1638001) ,

   $VDP009.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        1872001) ,

   $VDP010.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        2106001) ,

   $VDP011.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        2340001) ,

   $VDP012.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        2574001) ,

   $VDP013.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        2808001) ,

   $VDP014.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        3042001) ,

   $VDP015.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        3276001) ,

   $VDP016.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        3510001) ,

   $VDP017.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        3744001) ,

   $VDP018.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        3978001) ,

   $VDP019.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        4212001) ,

   $VDP020.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        4446001) ,

   $VDP021.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        4680001) ,

   $VDP022.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        4914001) ,

   $VDP023.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        5148001) ,

   $VDP024.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        5382001) ,

   $VDP025.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        5616001) ,

   $VDP026.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        5850001) ,

   $VDP027.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        6084001) ,

   $VDP028.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        6318001) ,

   $VDP029.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        6552001) ,

   $VDP030.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        6786001) ,

   $VDP031.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7020001) ,

   $VDP032.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7254001) ,

   $VDP033.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        7488001) ,

   $VDP034.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7722001) ,

   $VDP035.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        7956001) ,

   $VDP036.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        8190001) ,

   $VDP037.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        8424001) ,

   $VDP038.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        8658001) ,

   $VDP039.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        8892001) ,

   $VDP040.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        9126001) ,

   $VDP041.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (        9360001) ,

   $VDP042.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        9594001) ,

   $VDP043.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (        9828001) ,

   $VDP044.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       10062001) ,

   $VDP045.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       10296001) ,

   $VDP046.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       10530001) ,

   $VDP047.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       10764001) ,

   $VDP048.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       10998001) ,

   $VDP049.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       11232001) ,

   $VDP050.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       11466001) ,

   $VDP051.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       11700001) ,

   $VDP052.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       11934001) ,

   $VDP053.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       12168001) ,

   $VDP054.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       12402001) ,

   $VDP055.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       12636001) ,

   $VDP056.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       12870001) ,

   $VDP057.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       13104001) ,

   $VDP058.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       13338001) ,

   $VDP059.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       13572001) ,

   $VDP060.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       13806001) ,

   $VDP061.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       14040001) ,

   $VDP062.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       14274001) ,

   $VDP063.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA06
   first key (       14508001) ,

   $VDP064.$$NSK_SUBVOL$$.OX2
   CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
   PHYSVOL $DATA05
   first key (       14742001) )

buffered;
#ifMP

?section ox4
--------------------------------------------
--  Create priority index on order table. --
--------------------------------------------
#ifMX
Create unique index ox4 on orders
(
     o_orderkey 
   , o_orderpriority 
)
location $$partition2$$
partition( 
add first key        50000001     location    $$partition2$$,
add first key       100000001     location    $$partition1$$,
add first key       150000001     location    $$partition1$$,
add first key       200000001     location    $$partition2$$,
add first key       250000001     location    $$partition2$$,
add first key       300000001     location    $$partition1$$,
add first key       350000001     location    $$partition1$$,
add first key       400000001     location    $$partition2$$,
add first key       450000001     location    $$partition2$$,
add first key       500000001     location    $$partition1$$,
add first key       550000001     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create unique index $$NSK_VOL$$.$$NSK_SUBVOL$$.OX4 on $$NSK_VOL$$.$$NSK_SUBVOL$$.ORDERS
(
     o_orderkey 
   , o_orderpriority 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        50000001     ,

  $VDP003.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key       100000001     ,

  $VDP004.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key       150000001     ,

  $VDP005.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key       200000001     ,

  $VDP006.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key       250000001     ,

  $VDP007.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key       300000001     ,

  $VDP008.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key       350000001     ,

  $VDP009.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key       400000001     ,

  $VDP010.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key       450000001     ,

  $VDP011.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key       500000001     ,

  $VDP012.$$NSK_SUBVOL$$.OX4
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key       550000001      

)
buffered; 
#ifMP

?section part
------------------------
-- Create part table. --
------------------------
#ifMX
Create table part  (
   p_partkey           int                not null not droppable, 
   p_name              varchar(55)        not null not droppable, 
   p_mfgr              char(25)           not null not droppable, 
   p_brand             char(10)           not null not droppable, 
   p_type              varchar(25)        not null not droppable, 
   p_size              int                not null not droppable, 
   p_container         char(10)           not null not droppable, 
   p_retailprice       numeric(12,2)      not null not droppable, 
   p_comment           varchar(23)        not null not droppable, 
primary key (p_partkey)  not droppable) 
store by primary key 
location $$partition2$$
partition (
add first key          277778     location    $$partition2$$ ,
add first key          555555     location    $$partition1$$,
add first key          833332     location    $$partition1$$,
add first key         1111109     location    $$partition2$$ ,
add first key         1388886     location    $$partition2$$ ,
add first key         1666663     location    $$partition1$$,
add first key         1944440     location    $$partition1$$,
add first key         2222217     location    $$partition2$$ ,
add first key         2499994     location    $$partition2$$ ,
add first key         2777771     location    $$partition1$$,
add first key         3055548     location    $$partition1$$,
add first key         3333325     location    $$partition2$$ ,
add first key         3611102     location    $$partition2$$ ,
add first key         3888879     location    $$partition1$$,
add first key         4166656     location    $$partition1$$,
add first key         4444433     location    $$partition2$$ ,
add first key         4722210     location    $$partition2$$ ,
add first key         4999987     location    $$partition1$$,
add first key         5277764     location    $$partition1$$,
add first key         5555541     location    $$partition2$$ ,
add first key         5833318     location    $$partition2$$ ,
add first key         6111095     location    $$partition1$$,
add first key         6388872     location    $$partition1$$,
add first key         6666649     location    $$partition2$$ ,
add first key         6944426     location    $$partition2$$ ,
add first key         7222203     location    $$partition1$$,
add first key         7499980     location    $$partition1$$,
add first key         7777757     location    $$partition2$$ ,
add first key         8055534     location    $$partition2$$ ,
add first key         8333311     location    $$partition1$$,
add first key         8611088     location    $$partition1$$,
add first key         8888865     location    $$partition2$$ ,
add first key         9166642     location    $$partition2$$ ,
add first key         9444419     location    $$partition1$$,
add first key         9722196     location    $$partition1$$,
add first key         9999973     location    $$partition2$$ ,
add first key        10277750     location    $$partition2$$ ,
add first key        10555527     location    $$partition1$$,
add first key        10833304     location    $$partition1$$,
add first key        11111081     location    $$partition2$$ ,
add first key        11388858     location    $$partition2$$ ,
add first key        11666635     location    $$partition1$$,
add first key        11944412     location    $$partition1$$,
add first key        12222189     location    $$partition2$$ ,
add first key        12499966     location    $$partition2$$ ,
add first key        12777743     location    $$partition1$$,
add first key        13055520     location    $$partition1$$,
add first key        13333297     location    $$partition2$$ ,
add first key        13611074     location    $$partition2$$ ,
add first key        13888851     location    $$partition1$$,
add first key        14166628     location    $$partition1$$,
add first key        14444405     location    $$partition2$$ ,
add first key        14722182     location    $$partition2$$ ,
add first key        14999959     location    $$partition1$$,
add first key        15277736     location    $$partition1$$,
add first key        15555513     location    $$partition2$$ ,
add first key        15833290     location    $$partition2$$ ,
add first key        16111067     location    $$partition1$$,
add first key        16388844     location    $$partition1$$,
add first key        16666621     location    $$partition2$$ ,
add first key        16944398     location    $$partition2$$ ,
add first key        17222175     location    $$partition1$$,
add first key        17499952     location    $$partition1$$,
add first key        17777729     location    $$partition2$$ ,
add first key        18055506     location    $$partition2$$ ,
add first key        18333283     location    $$partition1$$,
add first key        18611060     location    $$partition1$$,
add first key        18888837     location    $$partition2$$ ,
add first key        19166614     location    $$partition2$$ ,
add first key        19444391     location    $$partition1$$,
add first key        19722168     location    $$partition1$$ 
)
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.PART (
   p_partkey           int                not null,
   p_name              varchar(55)        not null,
   p_mfgr              char(25)           not null,
   p_brand             char(10)           not null,
   p_type              varchar(25)        not null,
   p_size              int                not null,
   p_container         char(10)           not null,
   p_retailprice       numeric(12,2)      not null,
   p_comment           varchar(23)        not null,
primary key (p_partkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition (
  $VDP002.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          277778      ,

  $VDP003.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          555555      ,

  $VDP004.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          833332      ,

  $VDP005.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1111109      ,

  $VDP006.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1388886      ,

  $VDP007.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1666663      ,

  $VDP008.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1944440      ,

  $VDP009.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2222217      ,

  $VDP010.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2499994      ,

  $VDP011.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         2777771      ,

  $VDP012.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3055548      ,

  $VDP013.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3333325      ,

  $VDP014.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3611102      ,

  $VDP015.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3888879      ,

  $VDP016.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4166656      ,

  $VDP017.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4444433      ,

  $VDP018.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4722210      ,

  $VDP019.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4999987      ,

  $VDP020.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         5277764      ,

  $VDP021.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5555541      ,

  $VDP022.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5833318      ,

  $VDP023.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6111095      ,

  $VDP024.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6388872      ,

  $VDP025.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6666649      ,

  $VDP026.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6944426      ,

  $VDP027.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7222203      ,

  $VDP028.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7499980      ,

  $VDP029.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         7777757      ,

  $VDP030.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8055534      ,

  $VDP031.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8333311      ,

  $VDP032.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8611088      ,

  $VDP033.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8888865      ,

  $VDP034.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9166642      ,

  $VDP035.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9444419      ,

  $VDP036.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9722196      ,

  $VDP037.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9999973      ,

  $VDP038.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        10277750      ,

  $VDP039.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10555527      ,

  $VDP040.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10833304      ,

  $VDP041.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11111081      ,

  $VDP042.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11388858      ,

  $VDP043.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11666635      ,

  $VDP044.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11944412      ,

  $VDP045.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12222189      ,

  $VDP046.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12499966      ,

  $VDP047.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        12777743      ,

  $VDP048.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13055520      ,

  $VDP049.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13333297      ,

  $VDP050.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13611074      ,

  $VDP051.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13888851      ,

  $VDP052.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14166628      ,

  $VDP053.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14444405      ,

  $VDP054.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14722182      ,

  $VDP055.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14999959      ,

  $VDP056.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        15277736      ,

  $VDP057.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15555513      ,

  $VDP058.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15833290      ,

  $VDP059.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16111067      ,

  $VDP060.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16388844      ,

  $VDP061.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16666621      ,

  $VDP062.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16944398      ,

  $VDP063.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17222175      ,

  $VDP064.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17499952      ,

  $VDP065.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        17777729      ,

  $VDP066.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18055506      ,

  $VDP067.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18333283      ,

  $VDP068.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18611060      ,

  $VDP069.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18888837      ,

  $VDP070.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        19166614      ,

  $VDP071.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19444391      ,

  $VDP072.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19722168      

)

buffered audit;
#ifMP

?section px1
---------------------------------------------
--  Create type/size index on parts table. --
---------------------------------------------
#ifMX
Create unique index px1 on part
(
     p_type 
   , p_size 
   , p_mfgr 
   , p_brand 
   , p_container 
   , p_partkey 
)
location $$partition2$$
partition( 
-- Telling IDXBRK 277 Rows per partition 
add first key ('ECONOMY ANODIZED NICKEL',  10,'Manufacturer#2           ','Brand#22  ','LG BOX    ')     location    $$partition2$$,
add first key ('ECONOMY ANODIZED TIN',      7,'Manufacturer#4           ','Brand#45  ','MED DRUM  ')     location    $$partition1$$,
add first key ('ECONOMY BRUSHED COPPER',   10,'Manufacturer#5           ','Brand#52  ','LG CASE   ')     location    $$partition1$$,
add first key ('ECONOMY BRUSHED STEEL',    11,'Manufacturer#4           ','Brand#44  ','JUMBO JAR ')     location    $$partition2$$,
add first key ('ECONOMY BURNISHED BRASS',  15,'Manufacturer#4           ','Brand#42  ','MED JAR   ')     location    $$partition2$$,
add first key ('ECONOMY BURNISHED NICKEL', 20,'Manufacturer#1           ','Brand#13  ','MED PACK  ')     location    $$partition1$$,
add first key ('ECONOMY BURNISHED TIN',    35,'Manufacturer#2           ','Brand#22  ','LG BAG    ')     location    $$partition1$$,
add first key ('ECONOMY PLATED COPPER',    47,'Manufacturer#3           ','Brand#33  ','SM DRUM   ')     location    $$partition2$$,
add first key ('ECONOMY PLATED STEEL',     50,'Manufacturer#3           ','Brand#33  ','WRAP DRUM ')     location    $$partition2$$,
add first key ('ECONOMY POLISHED BRASS',   49,'Manufacturer#5           ','Brand#54  ','JUMBO BOX ')     location    $$partition1$$,
add first key ('ECONOMY POLISHED NICKEL',  50,'Manufacturer#3           ','Brand#32  ','JUMBO BAG ')     location    $$partition1$$,
add first key ('LARGE ANODIZED BRASS',      3,'Manufacturer#3           ','Brand#31  ','SM BOX    ')     location    $$partition2$$,
add first key ('LARGE ANODIZED NICKEL',     2,'Manufacturer#2           ','Brand#23  ','MED BOX   ')     location    $$partition2$$,
add first key ('LARGE ANODIZED TIN',        9,'Manufacturer#3           ','Brand#35  ','MED PACK  ')     location    $$partition1$$,
add first key ('LARGE BRUSHED COPPER',      4,'Manufacturer#5           ','Brand#51  ','MED CAN   ')     location    $$partition1$$,
add first key ('LARGE BRUSHED STEEL',      19,'Manufacturer#1           ','Brand#15  ','MED JAR   ')     location    $$partition2$$,
add first key ('LARGE BURNISHED BRASS',    25,'Manufacturer#5           ','Brand#51  ','MED DRUM  ')     location    $$partition2$$,
add first key ('LARGE BURNISHED NICKEL',   23,'Manufacturer#3           ','Brand#35  ','LG BOX    ')     location    $$partition1$$,
add first key ('LARGE BURNISHED TIN',      34,'Manufacturer#5           ','Brand#55  ','MED CAN   ')     location    $$partition1$$,
add first key ('LARGE PLATED COPPER',      35,'Manufacturer#1           ','Brand#13  ','MED PKG   ')     location    $$partition2$$,
add first key ('LARGE PLATED STEEL',       42,'Manufacturer#1           ','Brand#15  ','JUMBO BAG ')     location    $$partition2$$,
add first key ('LARGE POLISHED BRASS',     45,'Manufacturer#3           ','Brand#32  ','MED PACK  ')     location    $$partition1$$,
add first key ('LARGE POLISHED NICKEL',    40,'Manufacturer#5           ','Brand#52  ','SM JAR    ')     location    $$partition1$$,
add first key ('MEDIUM ANODIZED BRASS',     8,'Manufacturer#1           ','Brand#11  ','SM BOX    ')     location    $$partition2$$,
add first key ('MEDIUM ANODIZED NICKEL',   14,'Manufacturer#5           ','Brand#54  ','LG CAN    ')     location    $$partition2$$,
add first key ('MEDIUM ANODIZED TIN',      17,'Manufacturer#4           ','Brand#41  ','MED PKG   ')     location    $$partition1$$,
add first key ('MEDIUM BRUSHED COPPER',    10,'Manufacturer#1           ','Brand#14  ','JUMBO BAG ')     location    $$partition1$$,
add first key ('MEDIUM BRUSHED STEEL',      7,'Manufacturer#3           ','Brand#35  ','SM BAG    ')     location    $$partition2$$,
add first key ('MEDIUM BURNISHED BRASS',   13,'Manufacturer#1           ','Brand#15  ','WRAP DRUM ')     location    $$partition2$$,
add first key ('MEDIUM BURNISHED NICKEL',   8,'Manufacturer#3           ','Brand#33  ','MED CASE  ')     location    $$partition1$$,
add first key ('MEDIUM BURNISHED TIN',     16,'Manufacturer#2           ','Brand#25  ','LG BOX    ')     location    $$partition1$$,
add first key ('MEDIUM PLATED COPPER',     18,'Manufacturer#5           ','Brand#55  ','SM JAR    ')     location    $$partition2$$,
add first key ('MEDIUM PLATED STEEL',      17,'Manufacturer#3           ','Brand#35  ','SM JAR    ')     location    $$partition2$$,
add first key ('MEDIUM POLISHED BRASS',    16,'Manufacturer#2           ','Brand#25  ','MED PKG   ')     location    $$partition1$$,
add first key ('MEDIUM POLISHED NICKEL',   30,'Manufacturer#5           ','Brand#51  ','LG BAG    ')     location    $$partition1$$,
add first key ('MEDIUM POLISHED TIN',      31,'Manufacturer#1           ','Brand#15  ','SM BAG    ')     location    $$partition2$$,
add first key ('PROMO ANODIZED COPPER',    41,'Manufacturer#1           ','Brand#12  ','WRAP PKG  ')     location    $$partition2$$,
add first key ('PROMO ANODIZED STEEL',     49,'Manufacturer#1           ','Brand#12  ','WRAP BAG  ')     location    $$partition1$$,
add first key ('PROMO BRUSHED BRASS',      44,'Manufacturer#1           ','Brand#11  ','SM CAN    ')     location    $$partition1$$,
add first key ('PROMO BRUSHED NICKEL',     49,'Manufacturer#4           ','Brand#45  ','LG PACK   ')     location    $$partition2$$,
add first key ('PROMO BURNISHED BRASS',     2,'Manufacturer#4           ','Brand#45  ','SM PACK   ')     location    $$partition2$$,
add first key ('PROMO BURNISHED NICKEL',   10,'Manufacturer#2           ','Brand#25  ','MED PACK  ')     location    $$partition1$$,
add first key ('PROMO BURNISHED TIN',      16,'Manufacturer#3           ','Brand#32  ','JUMBO PKG ')     location    $$partition1$$,
add first key ('PROMO PLATED COPPER',      27,'Manufacturer#1           ','Brand#12  ','SM PACK   ')     location    $$partition2$$,
add first key ('PROMO PLATED STEEL',       38,'Manufacturer#2           ','Brand#23  ','WRAP DRUM ')     location    $$partition2$$,
add first key ('PROMO POLISHED BRASS',     31,'Manufacturer#5           ','Brand#53  ','WRAP PACK ')     location    $$partition1$$,
add first key ('PROMO POLISHED NICKEL',    33,'Manufacturer#2           ','Brand#22  ','LG DRUM   ')     location    $$partition1$$,
add first key ('PROMO POLISHED TIN',       40,'Manufacturer#1           ','Brand#14  ','LG CASE   ')     location    $$partition2$$,
add first key ('SMALL ANODIZED COPPER',    47,'Manufacturer#4           ','Brand#45  ','LG BOX    ')     location    $$partition2$$,
add first key ('SMALL ANODIZED STEEL',     46,'Manufacturer#3           ','Brand#33  ','LG PACK   ')     location    $$partition1$$,
add first key ('SMALL BRUSHED BRASS',      50,'Manufacturer#5           ','Brand#51  ','JUMBO CAN ')     location    $$partition1$$,
add first key ('SMALL BRUSHED NICKEL',     49,'Manufacturer#2           ','Brand#24  ','WRAP JAR  ')     location    $$partition2$$,
add first key ('SMALL BRUSHED TIN',        46,'Manufacturer#5           ','Brand#55  ','JUMBO CAN ')     location    $$partition2$$,
add first key ('SMALL BURNISHED NICKEL',    2,'Manufacturer#1           ','Brand#15  ','SM JAR    ')     location    $$partition1$$,
add first key ('SMALL BURNISHED TIN',       2,'Manufacturer#2           ','Brand#23  ','SM CAN    ')     location    $$partition1$$,
add first key ('SMALL PLATED COPPER',       4,'Manufacturer#4           ','Brand#42  ','WRAP BAG  ')     location    $$partition2$$,
add first key ('SMALL PLATED STEEL',        1,'Manufacturer#5           ','Brand#52  ','LG CAN    ')     location    $$partition2$$,
add first key ('SMALL POLISHED BRASS',     11,'Manufacturer#5           ','Brand#54  ','JUMBO JAR ')     location    $$partition1$$,
add first key ('SMALL POLISHED NICKEL',    13,'Manufacturer#4           ','Brand#41  ','LG PACK   ')     location    $$partition1$$,
add first key ('SMALL POLISHED TIN',       18,'Manufacturer#4           ','Brand#42  ','WRAP BOX  ')     location    $$partition2$$,
add first key ('STANDARD ANODIZED COPPER', 21,'Manufacturer#3           ','Brand#32  ','WRAP JAR  ')     location    $$partition2$$,
add first key ('STANDARD ANODIZED STEEL',  12,'Manufacturer#4           ','Brand#41  ','LG PKG    ')     location    $$partition1$$,
add first key ('STANDARD BRUSHED BRASS',   25,'Manufacturer#3           ','Brand#31  ','JUMBO PACK')     location    $$partition1$$,
add first key ('STANDARD BRUSHED NICKEL',  40,'Manufacturer#2           ','Brand#23  ','MED BOX   ')     location    $$partition2$$,
add first key ('STANDARD BRUSHED TIN',     39,'Manufacturer#4           ','Brand#45  ','MED JAR   ')     location    $$partition2$$,
add first key ('STANDARD BURNISHED COPPER',48,'Manufacturer#1           ','Brand#13  ','JUMBO BAG ')     location    $$partition1$$,
add first key ('STANDARD BURNISHED STEEL', 47,'Manufacturer#4           ','Brand#44  ','MED PKG   ')     location    $$partition1$$,
add first key ('STANDARD PLATED COPPER',   11,'Manufacturer#5           ','Brand#53  ','JUMBO PACK')     location    $$partition2$$,
add first key ('STANDARD PLATED STEEL',    16,'Manufacturer#3           ','Brand#34  ','SM DRUM   ')     location    $$partition2$$,
add first key ('STANDARD POLISHED BRASS',  21,'Manufacturer#1           ','Brand#12  ','MED CASE  ')     location    $$partition1$$,
add first key ('STANDARD POLISHED NICKEL', 24,'Manufacturer#2           ','Brand#21  ','LG CAN    ')     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create unique index $$NSK_VOL$$.$$NSK_SUBVOL$$.PX1 on $$NSK_VOL$$.$$NSK_SUBVOL$$.PART
(
     p_type 
   , p_size 
   , p_mfgr 
   , p_brand 
   , p_container 
   , p_partkey 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
-- Telling IDXBRK 277 Rows per partition 
  $VDP002.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('economy anodized nickel',  10,'manufacturer#2           ','brand#22  ','lg box    ')     ,

  $VDP003.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('economy anodized tin',      7,'manufacturer#4           ','brand#45  ','med drum  ')     ,

  $VDP004.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('economy brushed copper',   10,'manufacturer#5           ','brand#52  ','lg case   ')     ,

  $VDP005.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('economy brushed steel',    11,'manufacturer#4           ','brand#44  ','jumbo jar ')     ,

  $VDP006.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('economy burnished brass',  15,'manufacturer#4           ','brand#42  ','med jar   ')     ,

  $VDP007.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('economy burnished nickel', 20,'manufacturer#1           ','brand#13  ','med pack  ')     ,

  $VDP008.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('economy burnished tin',    35,'manufacturer#2           ','brand#22  ','lg bag    ')     ,

  $VDP009.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('economy plated copper',    47,'manufacturer#3           ','brand#33  ','sm drum   ')     ,

  $VDP010.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('economy plated steel',     50,'manufacturer#3           ','brand#33  ','wrap drum ')     ,

  $VDP011.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('economy polished brass',   49,'manufacturer#5           ','brand#54  ','jumbo box ')     ,

  $VDP012.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('economy polished nickel',  50,'manufacturer#3           ','brand#32  ','jumbo bag ')     ,

  $VDP013.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('large anodized brass',      3,'manufacturer#3           ','brand#31  ','sm box    ')     ,

  $VDP014.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('large anodized nickel',     2,'manufacturer#2           ','brand#23  ','med box   ')     ,

  $VDP015.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('large anodized tin',        9,'manufacturer#3           ','brand#35  ','med pack  ')     ,

  $VDP016.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('large brushed copper',      4,'manufacturer#5           ','brand#51  ','med can   ')     ,

  $VDP017.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('large brushed steel',      19,'manufacturer#1           ','brand#15  ','med jar   ')     ,

  $VDP018.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('large burnished brass',    25,'manufacturer#5           ','brand#51  ','med drum  ')     ,

  $VDP019.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('large burnished nickel',   23,'manufacturer#3           ','brand#35  ','lg box    ')     ,

  $VDP020.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('large burnished tin',      34,'manufacturer#5           ','brand#55  ','med can   ')     ,

  $VDP021.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('large plated copper',      35,'manufacturer#1           ','brand#13  ','med pkg   ')     ,

  $VDP022.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('large plated steel',       42,'manufacturer#1           ','brand#15  ','jumbo bag ')     ,

  $VDP023.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('large polished brass',     45,'manufacturer#3           ','brand#32  ','med pack  ')     ,

  $VDP024.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('large polished nickel',    40,'manufacturer#5           ','brand#52  ','sm jar    ')     ,

  $VDP025.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium anodized brass',     8,'manufacturer#1           ','brand#11  ','sm box    ')     ,

  $VDP026.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium anodized nickel',   14,'manufacturer#5           ','brand#54  ','lg can    ')     ,

  $VDP027.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('medium anodized tin',      17,'manufacturer#4           ','brand#41  ','med pkg   ')     ,

  $VDP028.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('medium brushed copper',    10,'manufacturer#1           ','brand#14  ','jumbo bag ')     ,

  $VDP029.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium brushed steel',      7,'manufacturer#3           ','brand#35  ','sm bag    ')     ,

  $VDP030.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium burnished brass',   13,'manufacturer#1           ','brand#15  ','wrap drum ')     ,

  $VDP031.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('medium burnished nickel',   8,'manufacturer#3           ','brand#33  ','med case  ')     ,

  $VDP032.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('medium burnished tin',     16,'manufacturer#2           ','brand#25  ','lg box    ')     ,

  $VDP033.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium plated copper',     18,'manufacturer#5           ','brand#55  ','sm jar    ')     ,

  $VDP034.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium plated steel',      17,'manufacturer#3           ','brand#35  ','sm jar    ')     ,

  $VDP035.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('medium polished brass',    16,'manufacturer#2           ','brand#25  ','med pkg   ')     ,

  $VDP036.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('medium polished nickel',   30,'manufacturer#5           ','brand#51  ','lg bag    ')     ,

  $VDP037.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('medium polished tin',      31,'manufacturer#1           ','brand#15  ','sm bag    ')     ,

  $VDP038.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('promo anodized copper',    41,'manufacturer#1           ','brand#12  ','wrap pkg  ')     ,

  $VDP039.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('promo anodized steel',     49,'manufacturer#1           ','brand#12  ','wrap bag  ')     ,

  $VDP040.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('promo brushed brass',      44,'manufacturer#1           ','brand#11  ','sm can    ')     ,

  $VDP041.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('promo brushed nickel',     49,'manufacturer#4           ','brand#45  ','lg pack   ')     ,

  $VDP042.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('promo burnished brass',     2,'manufacturer#4           ','brand#45  ','sm pack   ')     ,

  $VDP043.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('promo burnished nickel',   10,'manufacturer#2           ','brand#25  ','med pack  ')     ,

  $VDP044.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('promo burnished tin',      16,'manufacturer#3           ','brand#32  ','jumbo pkg ')     ,

  $VDP045.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('promo plated copper',      27,'manufacturer#1           ','brand#12  ','sm pack   ')     ,

  $VDP046.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('promo plated steel',       38,'manufacturer#2           ','brand#23  ','wrap drum ')     ,

  $VDP047.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('promo polished brass',     31,'manufacturer#5           ','brand#53  ','wrap pack ')     ,

  $VDP048.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('promo polished nickel',    33,'manufacturer#2           ','brand#22  ','lg drum   ')     ,

  $VDP049.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('promo polished tin',       40,'manufacturer#1           ','brand#14  ','lg case   ')     ,

  $VDP050.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('small anodized copper',    47,'manufacturer#4           ','brand#45  ','lg box    ')     ,

  $VDP051.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('small anodized steel',     46,'manufacturer#3           ','brand#33  ','lg pack   ')     ,

  $VDP052.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('small brushed brass',      50,'manufacturer#5           ','brand#51  ','jumbo can ')     ,

  $VDP053.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('small brushed nickel',     49,'manufacturer#2           ','brand#24  ','wrap jar  ')     ,

  $VDP054.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('small brushed tin',        46,'manufacturer#5           ','brand#55  ','jumbo can ')     ,

  $VDP055.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('small burnished nickel',    2,'manufacturer#1           ','brand#15  ','sm jar    ')     ,

  $VDP056.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('small burnished tin',       2,'manufacturer#2           ','brand#23  ','sm can    ')     ,

  $VDP057.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('small plated copper',       4,'manufacturer#4           ','brand#42  ','wrap bag  ')     ,

  $VDP058.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('small plated steel',        1,'manufacturer#5           ','brand#52  ','lg can    ')     ,

  $VDP059.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('small polished brass',     11,'manufacturer#5           ','brand#54  ','jumbo jar ')     ,

  $VDP060.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('small polished nickel',    13,'manufacturer#4           ','brand#41  ','lg pack   ')     ,

  $VDP061.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('small polished tin',       18,'manufacturer#4           ','brand#42  ','wrap box  ')     ,

  $VDP062.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('standard anodized copper', 21,'manufacturer#3           ','brand#32  ','wrap jar  ')     ,

  $VDP063.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('standard anodized steel',  12,'manufacturer#4           ','brand#41  ','lg pkg    ')     ,

  $VDP064.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('standard brushed brass',   25,'manufacturer#3           ','brand#31  ','jumbo pack')     ,

  $VDP065.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('standard brushed nickel',  40,'manufacturer#2           ','brand#23  ','med box   ')     ,

  $VDP066.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('standard brushed tin',     39,'manufacturer#4           ','brand#45  ','med jar   ')     ,

  $VDP067.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('standard burnished copper',48,'manufacturer#1           ','brand#13  ','jumbo bag ')     ,

  $VDP068.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('standard burnished steel', 47,'manufacturer#4           ','brand#44  ','med pkg   ')     ,

  $VDP069.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('standard plated copper',   11,'manufacturer#5           ','brand#53  ','jumbo pack')     ,

  $VDP070.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key ('standard plated steel',    16,'manufacturer#3           ','brand#34  ','sm drum   ')     ,

  $VDP071.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('standard polished brass',  21,'manufacturer#1           ','brand#12  ','med case  ')     ,

  $VDP072.$$NSK_SUBVOL$$.PX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key ('standard polished nickel', 24,'manufacturer#2           ','brand#21  ','lg can    ')      

)
buffered; 
#ifMP

?section  partsupp
-----------------------------
--  Create partsupp table. --
-----------------------------
#ifMX
Create table partsupp  (
   ps_partkey          int                not null not droppable, 
   ps_suppkey          int                not null not droppable, 
   ps_availqty         int                not null not droppable, 
   ps_supplycost       numeric(12,2)      not null not droppable, 
   ps_comment          varchar(199)       not null not droppable, 
primary key (ps_partkey,ps_suppkey)  not droppable) 
store by primary key 
location $$partition2$$
partition ( 
add first key          277778     location    $$partition2$$ ,
add first key          555555     location    $$partition1$$,
add first key          833332     location    $$partition1$$,
add first key         1111109     location    $$partition2$$ ,
add first key         1388886     location    $$partition2$$ ,
add first key         1666663     location    $$partition1$$,
add first key         1944440     location    $$partition1$$,
add first key         2222217     location    $$partition2$$ ,
add first key         2499994     location    $$partition2$$ ,
add first key         2777771     location    $$partition1$$,
add first key         3055548     location    $$partition1$$,
add first key         3333325     location    $$partition2$$ ,
add first key         3611102     location    $$partition2$$ ,
add first key         3888879     location    $$partition1$$,
add first key         4166656     location    $$partition1$$,
add first key         4444433     location    $$partition2$$ ,
add first key         4722210     location    $$partition2$$ ,
add first key         4999987     location    $$partition1$$,
add first key         5277764     location    $$partition1$$,
add first key         5555541     location    $$partition2$$ ,
add first key         5833318     location    $$partition2$$ ,
add first key         6111095     location    $$partition1$$,
add first key         6388872     location    $$partition1$$,
add first key         6666649     location    $$partition2$$ ,
add first key         6944426     location    $$partition2$$ ,
add first key         7222203     location    $$partition1$$,
add first key         7499980     location    $$partition1$$,
add first key         7777757     location    $$partition2$$ ,
add first key         8055534     location    $$partition2$$ ,
add first key         8333311     location    $$partition1$$,
add first key         8611088     location    $$partition1$$,
add first key         8888865     location    $$partition2$$ ,
add first key         9166642     location    $$partition2$$ ,
add first key         9444419     location    $$partition1$$,
add first key         9722196     location    $$partition1$$,
add first key         9999973     location    $$partition2$$ ,
add first key        10277750     location    $$partition2$$ ,
add first key        10555527     location    $$partition1$$,
add first key        10833304     location    $$partition1$$,
add first key        11111081     location    $$partition2$$ ,
add first key        11388858     location    $$partition2$$ ,
add first key        11666635     location    $$partition1$$,
add first key        11944412     location    $$partition1$$,
add first key        12222189     location    $$partition2$$ ,
add first key        12499966     location    $$partition2$$ ,
add first key        12777743     location    $$partition1$$,
add first key        13055520     location    $$partition1$$,
add first key        13333297     location    $$partition2$$ ,
add first key        13611074     location    $$partition2$$ ,
add first key        13888851     location    $$partition1$$,
add first key        14166628     location    $$partition1$$,
add first key        14444405     location    $$partition2$$ ,
add first key        14722182     location    $$partition2$$ ,
add first key        14999959     location    $$partition1$$,
add first key        15277736     location    $$partition1$$,
add first key        15555513     location    $$partition2$$ ,
add first key        15833290     location    $$partition2$$ ,
add first key        16111067     location    $$partition1$$,
add first key        16388844     location    $$partition1$$,
add first key        16666621     location    $$partition2$$ ,
add first key        16944398     location    $$partition2$$ ,
add first key        17222175     location    $$partition1$$,
add first key        17499952     location    $$partition1$$,
add first key        17777729     location    $$partition2$$ ,
add first key        18055506     location    $$partition2$$ ,
add first key        18333283     location    $$partition1$$,
add first key        18611060     location    $$partition1$$,
add first key        18888837     location    $$partition2$$ ,
add first key        19166614     location    $$partition2$$ ,
add first key        19444391     location    $$partition1$$,
add first key        19722168     location    $$partition1$$ 
)
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.PARTSUPP (
   ps_partkey          int                not null,
   ps_suppkey          int                not null,
   ps_availqty         int                not null,
   ps_supplycost       numeric(12,2)      not null,
   ps_comment          varchar(199)       not null,
primary key (ps_partkey,ps_suppkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition ( 
  $VDP002.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          277778      ,

  $VDP003.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          555555      ,

  $VDP004.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          833332      ,

  $VDP005.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1111109      ,

  $VDP006.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1388886      ,

  $VDP007.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1666663      ,

  $VDP008.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1944440      ,

  $VDP009.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2222217      ,

  $VDP010.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2499994      ,

  $VDP011.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         2777771      ,

  $VDP012.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3055548      ,

  $VDP013.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3333325      ,

  $VDP014.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3611102      ,

  $VDP015.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3888879      ,

  $VDP016.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4166656      ,

  $VDP017.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4444433      ,

  $VDP018.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4722210      ,

  $VDP019.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4999987      ,

  $VDP020.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         5277764      ,

  $VDP021.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5555541      ,

  $VDP022.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5833318      ,

  $VDP023.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6111095      ,

  $VDP024.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6388872      ,

  $VDP025.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6666649      ,

  $VDP026.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6944426      ,

  $VDP027.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7222203      ,

  $VDP028.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7499980      ,

  $VDP029.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         7777757      ,

  $VDP030.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8055534      ,

  $VDP031.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8333311      ,

  $VDP032.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8611088      ,

  $VDP033.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8888865      ,

  $VDP034.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9166642      ,

  $VDP035.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9444419      ,

  $VDP036.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9722196      ,

  $VDP037.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9999973      ,

  $VDP038.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        10277750      ,

  $VDP039.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10555527      ,

  $VDP040.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10833304      ,

  $VDP041.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11111081      ,

  $VDP042.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11388858      ,

  $VDP043.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11666635      ,

  $VDP044.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11944412      ,

  $VDP045.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12222189      ,

  $VDP046.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12499966      ,

  $VDP047.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        12777743      ,

  $VDP048.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13055520      ,

  $VDP049.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13333297      ,

  $VDP050.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13611074      ,

  $VDP051.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13888851      ,

  $VDP052.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14166628      ,

  $VDP053.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14444405      ,

  $VDP054.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14722182      ,

  $VDP055.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14999959      ,

  $VDP056.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        15277736      ,

  $VDP057.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15555513      ,

  $VDP058.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15833290      ,

  $VDP059.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16111067      ,

  $VDP060.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16388844      ,

  $VDP061.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16666621      ,

  $VDP062.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16944398      ,

  $VDP063.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17222175      ,

  $VDP064.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17499952      ,

  $VDP065.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        17777729      ,

  $VDP066.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18055506      ,

  $VDP067.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18333283      ,

  $VDP068.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18611060      ,

  $VDP069.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18888837      ,

  $VDP070.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        19166614      ,

  $VDP071.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19444391      ,

  $VDP072.$$NSK_SUBVOL$$.PART
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19722168      

)


buffered audit;
#ifMP

?section psx1
---------------------------------------------------
--  Create supplier key index on partsupp table. --
---------------------------------------------------
#ifMX
Create index psx1 on partsupp
(
     ps_suppkey 
   , ps_supplycost 
   , ps_availqty 
)
location $$partition2$$
partition( 
add first key           13889     location    $$partition2$$,
add first key           27777     location    $$partition1$$,
add first key           41665     location    $$partition1$$,
add first key           55553     location    $$partition2$$,
add first key           69441     location    $$partition2$$,
add first key           83329     location    $$partition1$$,
add first key           97217     location    $$partition1$$,
add first key          111105     location    $$partition2$$,
add first key          124993     location    $$partition2$$,
add first key          138881     location    $$partition1$$,
add first key          152769     location    $$partition1$$,
add first key          166657     location    $$partition2$$,
add first key          180545     location    $$partition2$$,
add first key          194433     location    $$partition1$$,
add first key          208321     location    $$partition1$$,
add first key          222209     location    $$partition2$$,
add first key          236097     location    $$partition2$$,
add first key          249985     location    $$partition1$$,
add first key          263873     location    $$partition1$$,
add first key          277761     location    $$partition2$$,
add first key          291649     location    $$partition2$$,
add first key          305537     location    $$partition1$$,
add first key          319425     location    $$partition1$$,
add first key          333313     location    $$partition2$$,
add first key          347201     location    $$partition2$$,
add first key          361089     location    $$partition1$$,
add first key          374977     location    $$partition1$$,
add first key          388865     location    $$partition2$$,
add first key          402753     location    $$partition2$$,
add first key          416641     location    $$partition1$$,
add first key          430529     location    $$partition1$$,
add first key          444417     location    $$partition2$$,
add first key          458305     location    $$partition2$$,
add first key          472193     location    $$partition1$$,
add first key          486081     location    $$partition1$$,
add first key          499969     location    $$partition2$$,
add first key          513857     location    $$partition2$$,
add first key          527745     location    $$partition1$$,
add first key          541633     location    $$partition1$$,
add first key          555521     location    $$partition2$$,
add first key          569409     location    $$partition2$$,
add first key          583297     location    $$partition1$$,
add first key          597185     location    $$partition1$$,
add first key          611073     location    $$partition2$$,
add first key          624961     location    $$partition2$$,
add first key          638849     location    $$partition1$$,
add first key          652737     location    $$partition1$$,
add first key          666625     location    $$partition2$$,
add first key          680513     location    $$partition2$$,
add first key          694401     location    $$partition1$$,
add first key          708289     location    $$partition1$$,
add first key          722177     location    $$partition2$$,
add first key          736065     location    $$partition2$$,
add first key          749953     location    $$partition1$$,
add first key          763841     location    $$partition1$$,
add first key          777729     location    $$partition2$$,
add first key          791617     location    $$partition2$$,
add first key          805505     location    $$partition1$$,
add first key          819393     location    $$partition1$$,
add first key          833281     location    $$partition2$$,
add first key          847169     location    $$partition2$$,
add first key          861057     location    $$partition1$$,
add first key          874945     location    $$partition1$$,
add first key          888833     location    $$partition2$$,
add first key          902721     location    $$partition2$$,
add first key          916609     location    $$partition1$$,
add first key          930497     location    $$partition1$$,
add first key          944385     location    $$partition2$$,
add first key          958273     location    $$partition2$$,
add first key          972161     location    $$partition1$$,
add first key          986049     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.PSX1 on $$NSK_VOL$$.$$NSK_SUBVOL$$.PARTSUPP
(
     ps_suppkey 
   , ps_supplycost 
   , ps_availqty 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key           13889     ,

  $VDP003.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           27777     ,

  $VDP004.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           41665     ,

  $VDP005.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key           55553     ,

  $VDP006.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key           69441     ,

  $VDP007.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           83329     ,

  $VDP008.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           97217     ,

  $VDP009.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          111105     ,

  $VDP010.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          124993     ,

  $VDP011.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          138881     ,

  $VDP012.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          152769     ,

  $VDP013.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          166657     ,

  $VDP014.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          180545     ,

  $VDP015.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          194433     ,

  $VDP016.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          208321     ,

  $VDP017.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          222209     ,

  $VDP018.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          236097     ,

  $VDP019.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          249985     ,

  $VDP020.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          263873     ,

  $VDP021.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          277761     ,

  $VDP022.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          291649     ,

  $VDP023.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          305537     ,

  $VDP024.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          319425     ,

  $VDP025.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          333313     ,

  $VDP026.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          347201     ,

  $VDP027.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          361089     ,

  $VDP028.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          374977     ,

  $VDP029.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          388865     ,

  $VDP030.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          402753     ,

  $VDP031.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          416641     ,

  $VDP032.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          430529     ,

  $VDP033.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          444417     ,

  $VDP034.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          458305     ,

  $VDP035.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          472193     ,

  $VDP036.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          486081     ,

  $VDP037.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          499969     ,

  $VDP038.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          513857     ,

  $VDP039.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          527745     ,

  $VDP040.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          541633     ,

  $VDP041.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          555521     ,

  $VDP042.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          569409     ,

  $VDP043.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          583297     ,

  $VDP044.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          597185     ,

  $VDP045.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          611073     ,

  $VDP046.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          624961     ,

  $VDP047.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          638849     ,

  $VDP048.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          652737     ,

  $VDP049.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          666625     ,

  $VDP050.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          680513     ,

  $VDP051.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          694401     ,

  $VDP052.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          708289     ,

  $VDP053.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          722177     ,

  $VDP054.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          736065     ,

  $VDP055.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          749953     ,

  $VDP056.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          763841     ,

  $VDP057.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          777729     ,

  $VDP058.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          791617     ,

  $VDP059.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          805505     ,

  $VDP060.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          819393     ,

  $VDP061.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          833281     ,

  $VDP062.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          847169     ,

  $VDP063.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          861057     ,

  $VDP064.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          874945     ,

  $VDP065.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          888833     ,

  $VDP066.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          902721     ,

  $VDP067.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          916609     ,

  $VDP068.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          930497     ,

  $VDP069.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          944385     ,

  $VDP070.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          958273     ,

  $VDP071.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          972161     ,

  $VDP072.$$NSK_SUBVOL$$.PSX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          986049      

)
buffered; 
#ifMP

?section psx2
--------------------------------------------------------
--  Supply cost/available quantity index on partsupp. --
--------------------------------------------------------
#ifMX
Create index psx2 on partsupp
(
     ps_partkey 
   , ps_suppkey 
   , ps_supplycost 
   , ps_availqty 
)
location $$partition2$$
partition( 
add first key          277778     location    $$partition2$$,
add first key          555555     location    $$partition1$$,
add first key          833332     location    $$partition1$$,
add first key         1111109     location    $$partition2$$,
add first key         1388886     location    $$partition2$$,
add first key         1666663     location    $$partition1$$,
add first key         1944440     location    $$partition1$$,
add first key         2222217     location    $$partition2$$,
add first key         2499994     location    $$partition2$$,
add first key         2777771     location    $$partition1$$,
add first key         3055548     location    $$partition1$$,
add first key         3333325     location    $$partition2$$,
add first key         3611102     location    $$partition2$$,
add first key         3888879     location    $$partition1$$,
add first key         4166656     location    $$partition1$$,
add first key         4444433     location    $$partition2$$,
add first key         4722210     location    $$partition2$$,
add first key         4999987     location    $$partition1$$,
add first key         5277764     location    $$partition1$$,
add first key         5555541     location    $$partition2$$,
add first key         5833318     location    $$partition2$$,
add first key         6111095     location    $$partition1$$,
add first key         6388872     location    $$partition1$$,
add first key         6666649     location    $$partition2$$,
add first key         6944426     location    $$partition2$$,
add first key         7222203     location    $$partition1$$,
add first key         7499980     location    $$partition1$$,
add first key         7777757     location    $$partition2$$,
add first key         8055534     location    $$partition2$$,
add first key         8333311     location    $$partition1$$,
add first key         8611088     location    $$partition1$$,
add first key         8888865     location    $$partition2$$,
add first key         9166642     location    $$partition2$$,
add first key         9444419     location    $$partition1$$,
add first key         9722196     location    $$partition1$$,
add first key         9999973     location    $$partition2$$,
add first key        10277750     location    $$partition2$$,
add first key        10555527     location    $$partition1$$,
add first key        10833304     location    $$partition1$$,
add first key        11111081     location    $$partition2$$,
add first key        11388858     location    $$partition2$$,
add first key        11666635     location    $$partition1$$,
add first key        11944412     location    $$partition1$$,
add first key        12222189     location    $$partition2$$,
add first key        12499966     location    $$partition2$$,
add first key        12777743     location    $$partition1$$,
add first key        13055520     location    $$partition1$$,
add first key        13333297     location    $$partition2$$,
add first key        13611074     location    $$partition2$$,
add first key        13888851     location    $$partition1$$,
add first key        14166628     location    $$partition1$$,
add first key        14444405     location    $$partition2$$,
add first key        14722182     location    $$partition2$$,
add first key        14999959     location    $$partition1$$,
add first key        15277736     location    $$partition1$$,
add first key        15555513     location    $$partition2$$,
add first key        15833290     location    $$partition2$$,
add first key        16111067     location    $$partition1$$,
add first key        16388844     location    $$partition1$$,
add first key        16666621     location    $$partition2$$,
add first key        16944398     location    $$partition2$$,
add first key        17222175     location    $$partition1$$,
add first key        17499952     location    $$partition1$$,
add first key        17777729     location    $$partition2$$,
add first key        18055506     location    $$partition2$$,
add first key        18333283     location    $$partition1$$,
add first key        18611060     location    $$partition1$$,
add first key        18888837     location    $$partition2$$,
add first key        19166614     location    $$partition2$$,
add first key        19444391     location    $$partition1$$,
add first key        19722168     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create index $$NSK_VOL$$.$$NSK_SUBVOL$$.PSX2 on $$NSK_VOL$$.$$NSK_SUBVOL$$.PARTSUPP
(
     ps_partkey 
   , ps_suppkey 
   , ps_supplycost 
   , ps_availqty 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          277778     ,

  $VDP003.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          555555     ,

  $VDP004.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          833332     ,

  $VDP005.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1111109     ,

  $VDP006.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         1388886     ,

  $VDP007.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1666663     ,

  $VDP008.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         1944440     ,

  $VDP009.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2222217     ,

  $VDP010.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         2499994     ,

  $VDP011.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         2777771     ,

  $VDP012.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3055548     ,

  $VDP013.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3333325     ,

  $VDP014.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         3611102     ,

  $VDP015.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         3888879     ,

  $VDP016.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4166656     ,

  $VDP017.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4444433     ,

  $VDP018.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         4722210     ,

  $VDP019.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         4999987     ,

  $VDP020.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         5277764     ,

  $VDP021.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5555541     ,

  $VDP022.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         5833318     ,

  $VDP023.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6111095     ,

  $VDP024.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         6388872     ,

  $VDP025.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6666649     ,

  $VDP026.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         6944426     ,

  $VDP027.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7222203     ,

  $VDP028.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         7499980     ,

  $VDP029.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         7777757     ,

  $VDP030.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8055534     ,

  $VDP031.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8333311     ,

  $VDP032.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         8611088     ,

  $VDP033.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         8888865     ,

  $VDP034.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9166642     ,

  $VDP035.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9444419     ,

  $VDP036.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key         9722196     ,

  $VDP037.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key         9999973     ,

  $VDP038.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        10277750     ,

  $VDP039.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10555527     ,

  $VDP040.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        10833304     ,

  $VDP041.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11111081     ,

  $VDP042.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        11388858     ,

  $VDP043.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11666635     ,

  $VDP044.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        11944412     ,

  $VDP045.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12222189     ,

  $VDP046.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        12499966     ,

  $VDP047.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        12777743     ,

  $VDP048.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13055520     ,

  $VDP049.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13333297     ,

  $VDP050.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        13611074     ,

  $VDP051.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        13888851     ,

  $VDP052.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14166628     ,

  $VDP053.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14444405     ,

  $VDP054.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        14722182     ,

  $VDP055.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        14999959     ,

  $VDP056.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        15277736     ,

  $VDP057.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15555513     ,

  $VDP058.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        15833290     ,

  $VDP059.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16111067     ,

  $VDP060.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        16388844     ,

  $VDP061.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16666621     ,

  $VDP062.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        16944398     ,

  $VDP063.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17222175     ,

  $VDP064.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        17499952     ,

  $VDP065.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        17777729     ,

  $VDP066.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18055506     ,

  $VDP067.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18333283     ,

  $VDP068.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        18611060     ,

  $VDP069.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        18888837     ,

  $VDP070.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key        19166614     ,

  $VDP071.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19444391     ,

  $VDP072.$$NSK_SUBVOL$$.PSX2
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key        19722168      

)
buffered; 
#ifMP

?section region
---------------------------
--  Create region table. --
---------------------------
#ifMX
Create table region  (
   r_regionkey         int                not null not droppable, 
   r_name              char(25)           not null not droppable, 
   r_comment           varchar(152)       not null not droppable, 
primary key (r_regionkey)  not droppable) 
store by primary key 
location $$partition2$$
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.REGION (
   r_regionkey         int                not null,
   r_name              char(25)           not null,
   r_comment           varchar(152)       not null,
primary key (r_regionkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
buffered audit;
#ifMP

--------------------------------------------------------------
--  Since region table is so small, insert its records now. --
--------------------------------------------------------------
prepare insertRegion from
insert into REGION values(?a, ?b, ?c);

BEGIN WORK;
set param ?a 0;
set param ?b 'AFRICA';
set param ?c 'xSx31zz31Cl1z4OAnmm05AjiOxC3AMMNOgC0kACgwngg3glP7LLLywlQy7R';
execute insertRegion;
set param ?a 1;
set param ?b 'AMERICA';
set param ?c 'kgyh3LSnC72k6zlAz0LP3k2L4QB1QL1O673OjO1SPj0ngQ7CO100SBgmgRQ4lgPCMk21A425iklyAR4yBRAwR4Cm5miNw 4jl13mMnxw17B';
execute insertRegion;
set param ?a 2;
set param ?b 'ASIA';
set param ?c 'NSg6xlMlA1lzm6mOR0Ajx nhRA77NgRxBwL1M6Py RjySB3RLwkyPkwMM2R1BQ xAzkOgkjmll0gAghinP5inmNmR76MlijMS3S2zxONR15';
execute insertRegion;
set param ?a 3;
set param ?b 'EUROPE';
set param ?c 'zlSL7Qwg12hMBL5lhlz0M45QkjShwSyiO04MLOh7wn1ARLQPyPAyAiil576l1Li7AlnR1S RQ4SLny7B2Ryj5P66MLhn NxhwB4C3ig0SO';
execute insertRegion;
set param ?a 4;
set param ?b 'MIDDLE EAST';
set param ?c 'RllxmhPLz3Cy2mNlg4QMBnNASM ACki MPki7Oi';
execute insertRegion;
COMMIT WORK;

?section supplier
-----------------------------
--  Create supplier table. --
-----------------------------
#ifMX
Create table supplier  (
   s_suppkey           int                not null not droppable, 
   s_name              char(25)           not null not droppable, 
   s_address           varchar(40)        not null not droppable, 
   s_nationkey         int                not null not droppable, 
   s_phone             char(15)           not null not droppable, 
   s_acctbal           numeric(12,2)      not null not droppable, 
   s_comment           varchar(101)       not null not droppable, 
primary key (s_suppkey)  not droppable) 
store by primary key 
location $$partition2$$
partition ( 
add first key           13889     location    $$partition2$$,
add first key           27777     location    $$partition1$$,
add first key           41665     location    $$partition1$$,
add first key           55553     location    $$partition2$$,
add first key           69441     location    $$partition2$$,
add first key           83329     location    $$partition1$$,
add first key           97217     location    $$partition1$$,
add first key          111105     location    $$partition2$$,
add first key          124993     location    $$partition2$$,
add first key          138881     location    $$partition1$$,
add first key          152769     location    $$partition1$$,
add first key          166657     location    $$partition2$$,
add first key          180545     location    $$partition2$$,
add first key          194433     location    $$partition1$$,
add first key          208321     location    $$partition1$$,
add first key          222209     location    $$partition2$$,
add first key          236097     location    $$partition2$$,
add first key          249985     location    $$partition1$$,
add first key          263873     location    $$partition1$$,
add first key          277761     location    $$partition2$$,
add first key          291649     location    $$partition2$$,
add first key          305537     location    $$partition1$$,
add first key          319425     location    $$partition1$$,
add first key          333313     location    $$partition2$$,
add first key          347201     location    $$partition2$$,
add first key          361089     location    $$partition1$$,
add first key          374977     location    $$partition1$$,
add first key          388865     location    $$partition2$$,
add first key          402753     location    $$partition2$$,
add first key          416641     location    $$partition1$$,
add first key          430529     location    $$partition1$$,
add first key          444417     location    $$partition2$$,
add first key          458305     location    $$partition2$$,
add first key          472193     location    $$partition1$$,
add first key          486081     location    $$partition1$$,
add first key          499969     location    $$partition2$$,
add first key          513857     location    $$partition2$$,
add first key          527745     location    $$partition1$$,
add first key          541633     location    $$partition1$$,
add first key          555521     location    $$partition2$$,
add first key          569409     location    $$partition2$$,
add first key          583297     location    $$partition1$$,
add first key          597185     location    $$partition1$$,
add first key          611073     location    $$partition2$$,
add first key          624961     location    $$partition2$$,
add first key          638849     location    $$partition1$$,
add first key          652737     location    $$partition1$$,
add first key          666625     location    $$partition2$$,
add first key          680513     location    $$partition2$$,
add first key          694401     location    $$partition1$$,
add first key          708289     location    $$partition1$$,
add first key          722177     location    $$partition2$$,
add first key          736065     location    $$partition2$$,
add first key          749953     location    $$partition1$$,
add first key          763841     location    $$partition1$$,
add first key          777729     location    $$partition2$$,
add first key          791617     location    $$partition2$$,
add first key          805505     location    $$partition1$$,
add first key          819393     location    $$partition1$$,
add first key          833281     location    $$partition2$$,
add first key          847169     location    $$partition2$$,
add first key          861057     location    $$partition1$$,
add first key          874945     location    $$partition1$$,
add first key          888833     location    $$partition2$$,
add first key          902721     location    $$partition2$$,
add first key          916609     location    $$partition1$$,
add first key          930497     location    $$partition1$$,
add first key          944385     location    $$partition2$$,
add first key          958273     location    $$partition2$$,
add first key          972161     location    $$partition1$$,
add first key          986049     location    $$partition1$$ 
)
;
-- BUFFERED is not supported; AUDIT is the default
-- attribute buffered, audit;
#ifMX

#ifMP
create table $$NSK_VOL$$.$$NSK_SUBVOL$$.SUPPLIER (
   s_suppkey           int                not null,
   s_name              char(25)           not null,
   s_address           varchar(40)        not null,
   s_nationkey         int                not null,
   s_phone             char(15)           not null,
   s_acctbal           numeric(12,2)      not null,
   s_comment           varchar(101)       not null,
primary key (s_suppkey) )
organization key sequenced
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition ( 
  $VDP002.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key           13889     ,

  $VDP003.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           27777     ,

  $VDP004.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           41665     ,

  $VDP005.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key           55553     ,

  $VDP006.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key           69441     ,

  $VDP007.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           83329     ,

  $VDP008.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key           97217     ,

  $VDP009.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          111105     ,

  $VDP010.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          124993     ,

  $VDP011.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          138881     ,

  $VDP012.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          152769     ,

  $VDP013.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          166657     ,

  $VDP014.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          180545     ,

  $VDP015.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          194433     ,

  $VDP016.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          208321     ,

  $VDP017.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          222209     ,

  $VDP018.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          236097     ,

  $VDP019.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          249985     ,

  $VDP020.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          263873     ,

  $VDP021.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          277761     ,

  $VDP022.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          291649     ,

  $VDP023.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          305537     ,

  $VDP024.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          319425     ,

  $VDP025.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          333313     ,

  $VDP026.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          347201     ,

  $VDP027.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          361089     ,

  $VDP028.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          374977     ,

  $VDP029.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          388865     ,

  $VDP030.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          402753     ,

  $VDP031.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          416641     ,

  $VDP032.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          430529     ,

  $VDP033.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          444417     ,

  $VDP034.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          458305     ,

  $VDP035.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          472193     ,

  $VDP036.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          486081     ,

  $VDP037.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          499969     ,

  $VDP038.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          513857     ,

  $VDP039.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          527745     ,

  $VDP040.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          541633     ,

  $VDP041.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          555521     ,

  $VDP042.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          569409     ,

  $VDP043.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          583297     ,

  $VDP044.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          597185     ,

  $VDP045.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          611073     ,

  $VDP046.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          624961     ,

  $VDP047.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          638849     ,

  $VDP048.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          652737     ,

  $VDP049.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          666625     ,

  $VDP050.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          680513     ,

  $VDP051.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          694401     ,

  $VDP052.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          708289     ,

  $VDP053.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          722177     ,

  $VDP054.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          736065     ,

  $VDP055.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          749953     ,

  $VDP056.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          763841     ,

  $VDP057.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          777729     ,

  $VDP058.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          791617     ,

  $VDP059.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          805505     ,

  $VDP060.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          819393     ,

  $VDP061.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          833281     ,

  $VDP062.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          847169     ,

  $VDP063.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          861057     ,

  $VDP064.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          874945     ,

  $VDP065.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          888833     ,

  $VDP066.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          902721     ,

  $VDP067.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          916609     ,

  $VDP068.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          930497     ,

  $VDP069.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          944385     ,

  $VDP070.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key          958273     ,

  $VDP071.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          972161     ,

  $VDP072.$$NSK_SUBVOL$$.SUPPLIER
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key          986049      

)

buffered audit;
#ifMP

?section sx1
-------------------------------------------------
--  Create nation key index on supplier table. --
-------------------------------------------------
#ifMX
Create unique index sx1 on supplier
(
     s_nationkey 
   , s_suppkey 
)
location $$partition2$$
partition( 
add first key               3     location    $$partition2$$,
add first key               5     location    $$partition1$$,
add first key               7     location    $$partition1$$,
add first key               9     location    $$partition2$$,
add first key              11     location    $$partition2$$,
add first key              13     location    $$partition1$$,
add first key              15     location    $$partition1$$,
add first key              17     location    $$partition2$$,
add first key              19     location    $$partition2$$,
add first key              21     location    $$partition1$$,
add first key              23     location    $$partition1$$ 
)
;
-- BUFFERED is not supported
-- attribute buffered; 
#ifMX

#ifMP
create unique index $$NSK_VOL$$.$$NSK_SUBVOL$$.SX1 on $$NSK_VOL$$.$$NSK_SUBVOL$$.SUPPLIER
(
     s_nationkey 
   , s_suppkey 
)
catalog $$NSK_VOL$$.$$NSK_SUBVOL$$
partition( 
  $VDP002.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key               3     ,

  $VDP003.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key               5     ,

  $VDP004.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key               7     ,

  $VDP005.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key               9     ,

  $VDP006.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key              11     ,

  $VDP007.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              13     ,

  $VDP008.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              15     ,

  $VDP009.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key              17     ,

  $VDP010.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA06
  first key              19     ,

  $VDP011.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              21     ,

  $VDP012.$$NSK_SUBVOL$$.SX1
  CATALOG $$NSK_VOL$$.$$NSK_SUBVOL$$
  PHYSVOL $DATA05
  first key              23      

)
buffered; 
#ifMP

?section stopLog
---------------------------
--  Stop logging output. --
---------------------------
LOG; 
