DB2创建分区表

CREATE TABLE <模式>.<表名> (

USER_ID INTEGER NOT NULL, NAME VARCHAR(30),....<表字段名、类型、长度等>

)--以上是正常创建表步骤，以下是创建分区表需要增加的

in tbs_data index in tbs_indx partition by range(part_day)

(
partition p001 starting 1 ending 1,
partition p002 starting 2 ending 2,
partition p003 starting 3 ending 3,
partition p004 starting 4 ending 4,
partition p005 starting 5 ending 5,
partition p006 starting 6 ending 6,
partition p007 starting 7 ending 7,
partition p008 starting 8 ending 8,
partition p009 starting 9 ending 9,
partition p010 starting 10 ending 10,
partition p011 starting 11 ending 11,
partition p012 starting 12 ending 12,
partition p013 starting 13 ending 13,
partition p014 starting 14 ending 14,
partition p015 starting 15 ending 15,
partition p016 starting 16 ending 16,
partition p017 starting 17 ending 17,
partition p018 starting 18 ending 18,
partition p019 starting 19 ending 19,
partition p020 starting 20 ending 20,
partition p021 starting 21 ending 21,
partition p022 starting 22 ending 22,
partition p023 starting 23 ending 23,
partition p024 starting 24 ending 24,
partition p025 starting 25 ending 25,
partition p026 starting 26 ending 26,
partition p027 starting 27 ending 27,
partition p028 starting 28 ending 28,
partition p029 starting 29 ending 29,
partition p030 starting 30 ending 30,
partition p031 starting 31 ending 31,
partition p032 starting 32 ending 32,
partition p033 starting 33 ending 33,
partition p034 starting 34 ending 34,
partition p035 starting 35 ending 35,
partition p036 starting 36 ending 36,
partition p037 starting 37 ending 37,
partition p038 starting 38 ending 38,
partition p039 starting 39 ending 39,
partition p040 starting 40 ending 40,
partition p041 starting 41 ending 41,
partition p042 starting 42 ending 42,
partition p043 starting 43 ending 43,
partition p044 starting 44 ending 44,
partition p045 starting 45 ending 45,
partition p046 starting 46 ending 46,
partition p047 starting 47 ending 47,
partition p048 starting 48 ending 48,
partition p049 starting 49 ending 49,
partition p050 starting 50 ending 50,
partition p051 starting 51 ending 51,
partition p052 starting 52 ending 52,
partition p053 starting 53 ending 53,
partition p054 starting 54 ending 54,
partition p055 starting 55 ending 55,
partition p056 starting 56 ending 56,
partition p057 starting 57 ending 57,
partition p058 starting 58 ending 58,
partition p059 starting 59 ending 59,
partition p060 starting 60 ending 60,
partition p061 starting 61 ending 61,
partition p062 starting 62 ending 62,
partition p063 starting 63 ending 63,
partition p064 starting 64 ending 64,
partition p065 starting 65 ending 65,
partition p066 starting 66 ending 66,
partition p067 starting 67 ending 67,
partition p068 starting 68 ending 68,
partition p069 starting 69 ending 69,
partition p070 starting 70 ending 70,
partition p071 starting 71 ending 71,
partition p072 starting 72 ending 72,