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,
partition p073 starting 73 ending 73,
partition p074 starting 74 ending 74,
partition p075 starting 75 ending 75,
partition p076 starting 76 ending 76,
partition p077 starting 77 ending 77,
partition p078 starting 78 ending 78,
partition p079 starting 79 ending 79,
partition p080 starting 80 ending 80,
partition p081 starting 81 ending 81,
partition p082 starting 82 ending 82,
partition p083 starting 83 ending 83,
partition p084 starting 84 ending 84,
partition p085 starting 85 ending 85,
partition p086 starting 86 ending 86,
partition p087 starting 87 ending 87,
partition p088 starting 88 ending 88,
partition p089 starting 89 ending 89,
partition p090 starting 90 ending 90,
partition p091 starting 91 ending 91,
partition p092 starting 92 ending 92,
partition p093 starting 93 ending 93,
partition p094 starting 94 ending 94,
partition p095 starting 95 ending 95,
partition p096 starting 96 ending 96,
partition p097 starting 97 ending 97,
partition p098 starting 98 ending 98,
partition p099 starting 99 ending 99,
partition p100 starting 100 ending 100,
partition p101 starting 101 ending 101,
partition p102 starting 102 ending 102,
partition p103 starting 103 ending 103,
partition p104 starting 104 ending 104,
partition p105 starting 105 ending 105,
partition p106 starting 106 ending 106,
partition p107 starting 107 ending 107,
partition p108 starting 108 ending 108,
partition p109 starting 109 ending 109,
partition p110 starting 110 ending 110,
partition p111 starting 111 ending 111,
partition p112 starting 112 ending 112,
partition p113 starting 113 ending 113,
partition p114 starting 114 ending 114,
partition p115 starting 115 ending 115,
partition p116 starting 116 ending 116,
partition p117 starting 117 ending 117,
partition p118 starting 118 ending 118,
partition p119 starting 119 ending 119,
partition p120 starting 120 ending 120,
partition p121 starting 121 ending 121,
partition p122 starting 122 ending 122,
partition p123 starting 123 ending 123,
partition p124 starting 124 ending 124,
partition p125 starting 125 ending 125,
partition p126 starting 126 ending 126,
partition p127 starting 127 ending 127,
partition p128 starting 128 ending 128,
partition p129 starting 129 ending 129,
partition p130 starting 130 ending 130,
partition p131 starting 131 ending 131,
partition p132 starting 132 ending 132,
partition p133 starting 133 ending 133,
partition p134 starting 134 ending 134,
partition p135 starting 135 ending 135,
partition p136 starting 136 ending 136,
partition p137 starting 137 ending 137,
partition p138 starting 138 ending 138,
partition p139 starting 139 ending 139,
partition p140 starting 140 ending 140,
partition p141 starting 141 ending 141,
partition p142 starting 142 ending 142,
partition p143 starting 143 ending 143,
partition p144 starting 144 ending 144,
partition p145 starting 145 ending 145,
partition p146 starting 146 ending 146,
partition p147 starting 147 ending 147,
partition p148 starting 148 ending 148,
partition p149 starting 149 ending 149,
partition p150 starting 150 ending 150,
partition p151 starting 151 ending 151,
partition p152 starting 152 ending 152,
partition p153 starting 153 ending 153,
partition p154 starting 154 ending 154,
partition p155 starting 155 ending 155,
partition p156 starting 156 ending 156,
partition p157 starting 157 ending 157,
partition p158 starting 158 ending 158,
partition p159 starting 159 ending 159,
partition p160 starting 160 ending 160,
partition p161 starting 161 ending 161,
partition p162 starting 162 ending 162,
partition p163 starting 163 ending 163,
partition p164 starting 164 ending 164,
partition p165 starting 165 ending 165,
partition p166 starting 166 ending 166,
partition p167 starting 167 ending 167,
partition p168 starting 168 ending 168,
partition p169 starting 169 ending 169,
partition p170 starting 170 ending 170,
partition p171 starting 171 ending 171,
partition p172 starting 172 ending 172,
partition p173 starting 173 ending 173,
partition p174 starting 174 ending 174,
partition p175 starting 175 ending 175,
partition p176 starting 176 ending 176,
partition p177 starting 177 ending 177,
partition p178 starting 178 ending 178,
partition p179 starting 179 ending 179,
partition p180 starting 180 ending 180,
partition p181 starting 181 ending 181,
partition p182 starting 182 ending 182,
partition p183 starting 183 ending 183,
partition p184 starting 184 ending 184,
partition p185 starting 185 ending 185,
partition p186 starting 186 ending 186,
partition p187 starting 187 ending 187,
partition p188 starting 188 ending 188,
partition p189 starting 189 ending 189,
partition p190 starting 190 ending 190,
partition p191 starting 191 ending 191,
partition p192 starting 192 ending 192,
partition p193 starting 193 ending 193,
partition p194 starting 194 ending 194,
partition p195 starting 195 ending 195,
partition p196 starting 196 ending 196,
partition p197 starting 197 ending 197,
partition p198 starting 198 ending 198,
partition p199 starting 199 ending 199,
partition p200 starting 200 ending 200,
partition p201 starting 201 ending 201,
partition p202 starting 202 ending 202,
partition p203 starting 203 ending 203,
partition p204 starting 204 ending 204,
partition p205 starting 205 ending 205,
partition p206 starting 206 ending 206,
partition p207 starting 207 ending 207,
partition p208 starting 208 ending 208,
partition p209 starting 209 ending 209,
partition p210 starting 210 ending 210,
partition p211 starting 211 ending 211,
partition p212 starting 212 ending 212,
partition p213 starting 213 ending 213,
partition p214 starting 214 ending 214,
partition p215 starting 215 ending 215,
partition p216 starting 216 ending 216,
partition p217 starting 217 ending 217,
partition p218 starting 218 ending 218,
partition p219 starting 219 ending 219,
partition p220 starting 220 ending 220,
partition p221 starting 221 ending 221,
partition p222 starting 222 ending 222,
partition p223 starting 223 ending 223,
partition p224 starting 224 ending 224,
partition p225 starting 225 ending 225,
partition p226 starting 226 ending 226,
partition p227 starting 227 ending 227,
partition p228 starting 228 ending 228,
partition p229 starting 229 ending 229,
partition p230 starting 230 ending 230,
partition p231 starting 231 ending 231,
partition p232 starting 232 ending 232,
partition p233 starting 233 ending 233,
partition p234 starting 234 ending 234,
partition p235 starting 235 ending 235,
partition p236 starting 236 ending 236,
partition p237 starting 237 ending 237,
partition p238 starting 238 ending 238,
partition p239 starting 239 ending 239,
partition p240 starting 240 ending 240,
partition p241 starting 241 ending 241,
partition p242 starting 242 ending 242,
partition p243 starting 243 ending 243,
partition p244 starting 244 ending 244,
partition p245 starting 245 ending 245,
partition p246 starting 246 ending 246,
partition p247 starting 247 ending 247,
partition p248 starting 248 ending 248,
partition p249 starting 249 ending 249,
partition p250 starting 250 ending 250,
partition p251 starting 251 ending 251,
partition p252 starting 252 ending 252,
partition p253 starting 253 ending 253,
partition p254 starting 254 ending 254,
partition p255 starting 255 ending 255,
partition p256 starting 256 ending 256,
partition p257 starting 257 ending 257,
partition p258 starting 258 ending 258,
partition p259 starting 259 ending 259,
partition p260 starting 260 ending 260,
partition p261 starting 261 ending 261,
partition p262 starting 262 ending 262,
partition p263 starting 263 ending 263,
partition p264 starting 264 ending 264,
partition p265 starting 265 ending 265,
partition p266 starting 266 ending 266,
partition p267 starting 267 ending 267,
partition p268 starting 268 ending 268,
partition p269 starting 269 ending 269,
partition p270 starting 270 ending 270,
partition p271 starting 271 ending 271,
partition p272 starting 272 ending 272,
partition p273 starting 273 ending 273,
partition p274 starting 274 ending 274,
partition p275 starting 275 ending 275,
partition p276 starting 276 ending 276,
partition p277 starting 277 ending 277,
partition p278 starting 278 ending 278,
partition p279 starting 279 ending 279,
partition p280 starting 280 ending 280,
partition p281 starting 281 ending 281,
partition p282 starting 282 ending 282,
partition p283 starting 283 ending 283,
partition p284 starting 284 ending 284,
partition p285 starting 285 ending 285,
partition p286 starting 286 ending 286,
partition p287 starting 287 ending 287,
partition p288 starting 288 ending 288,
partition p289 starting 289 ending 289,
partition p290 starting 290 ending 290,
partition p291 starting 291 ending 291,
partition p292 starting 292 ending 292,
partition p293 starting 293 ending 293,
partition p294 starting 294 ending 294,
partition p295 starting 295 ending 295,
partition p296 starting 296 ending 296,
partition p297 starting 297 ending 297,
partition p298 starting 298 ending 298,
partition p299 starting 299 ending 299,
partition p300 starting 300 ending 300,
partition p301 starting 301 ending 301,
partition p302 starting 302 ending 302,
partition p303 starting 303 ending 303,
partition p304 starting 304 ending 304,
partition p305 starting 305 ending 305,
partition p306 starting 306 ending 306,
partition p307 starting 307 ending 307,
partition p308 starting 308 ending 308,
partition p309 starting 309 ending 309,
partition p310 starting 310 ending 310,
partition p311 starting 311 ending 311,
partition p312 starting 312 ending 312,
partition p313 starting 313 ending 313,
partition p314 starting 314 ending 314,
partition p315 starting 315 ending 315,
partition p316 starting 316 ending 316,
partition p317 starting 317 ending 317,
partition p318 starting 318 ending 318,
partition p319 starting 319 ending 319,
partition p320 starting 320 ending 320,
partition p321 starting 321 ending 321,
partition p322 starting 322 ending 322,
partition p323 starting 323 ending 323,
partition p324 starting 324 ending 324,
partition p325 starting 325 ending 325,
partition p326 starting 326 ending 326,
partition p327 starting 327 ending 327,
partition p328 starting 328 ending 328,
partition p329 starting 329 ending 329,
partition p330 starting 330 ending 330,
partition p331 starting 331 ending 331,
partition p332 starting 332 ending 332,
partition p333 starting 333 ending 333,
partition p334 starting 334 ending 334,
partition p335 starting 335 ending 335,
partition p336 starting 336 ending 336,
partition p337 starting 337 ending 337,
partition p338 starting 338 ending 338,
partition p339 starting 339 ending 339,
partition p340 starting 340 ending 340,
partition p341 starting 341 ending 341,
partition p342 starting 342 ending 342,
partition p343 starting 343 ending 343,
partition p344 starting 344 ending 344,
partition p345 starting 345 ending 345,
partition p346 starting 346 ending 346,
partition p347 starting 347 ending 347,
partition p348 starting 348 ending 348,
partition p349 starting 349 ending 349,
partition p350 starting 350 ending 350,
partition p351 starting 351 ending 351,
partition p352 starting 352 ending 352,
partition p353 starting 353 ending 353,
partition p354 starting 354 ending 354,
partition p355 starting 355 ending 355,
partition p356 starting 356 ending 356,
partition p357 starting 357 ending 357,
partition p358 starting 358 ending 358,
partition p359 starting 359 ending 359,
partition p360 starting 360 ending 360,
partition p361 starting 361 ending 361,
partition p362 starting 362 ending 362,
partition p363 starting 363 ending 363,
partition p364 starting 364 ending 364,
partition p365 starting 365 ending 365,
partition p366 starting 366 ending 366
);