Table sizes and table space names

The default sizes and table space names for tables with the ASN, IWH, WCA, WCAETL, WCAMNG, and WCATMP schemas are shown in the following table:

Table name Tablespace name Sum of column sizes (in bytes) Number of rows Size (in bytes) Number of pages (size / 4096)
Tables in ASN schema
IBMSNAP_APPLYTRAIL WCA 1,078 1,000 1,078,000 263
IBMSNAP_CCPPARMS WCA 16 1,000 16,000 4
IBMSNAP_CRITSEC WCA 18 1,000 1,8000 4
IBMSNAP_PRUNCNTL WCA 176 1,000 176,000 43
IBMSNAP_PRUNE_LOCK WCA 1 1,000 1,000 0
IBMSNAP_REGISTER WCA 469 1,000 46,9000 115
IBMSNAP_SCHEMA_CHG WCA 46 1,000 46,000 11
IBMSNAP_SUBS_COLS WCA 349 1,000 349,000 85
IBMSNAP_SUBS_EVENT WCA 38 1,000 38,000 9
IBMSNAP_SUBS_MEMBR WCA 627 1,000 627,000 153
IBMSNAP_SUBS_SET WCA 166 1,000 166,000 41
IBMSNAP_SUBS_STMTS WCA 1,115 1,000 1,115,000 272
IBMSNAP_SUBS_TGTS WCA 83 1,000 83,000 20
IBMSNAP_TRACE WCA 272 1,000 272,000 66
IBMSNAP_UOW WCA 79 1,000 79,000 19
IBMSNAP_WARM_START WCA 45 1,000 45,000 11

Tables in IWH schema

ACCOUNT_R WCA 280 1,000 280,000 68
ADDRESS_R WCA 2,350 1,000 2,350,000 574
ATTRIBUTE_R WCA 834 1,000 834, 000 204
BASEITEM_R WCA 154 1,000 154,000 38
BUYERPO_R WCA 71 1,000 71,000 17
CAMPAIGN_R WCA 427 1,000 427,000 104
CATALOGDSC_R WCA 552 1,000 552,000 135
CATALOG_R WCA 302 1,000 302,000 74
CATENTDESC_R WCA 366 1,000 366,000 89
CATENTREL_R WCA 56 1,000 56,000 14
CATENTRY_R WCA 290 1,000 290,000 71
CATENTSHIP_R WCA 136 1,000 136,000 33
CATGPENREL_R WCA 56 1,000 56,000 14
CATGRPDESC_R WCA 552 1,000 552,000 135
CATGRPREL_R WCA 64 1,000 64,000 16
CATTOGRP_R WCA 48 1,000 48,000 12
CONTRACT_R WCA 314 1,000 314,000 77
CPGNLOG_R WCA 314 1,000 314,000 77
CPGNSTAT_R WCA 56 1,000 56,000 14
CURCONVERT_R WCA 80 1,000 80,000 20
EMSPOT_R WCA_TAB8K 33,342 1,000 33,342,000 8,140
FFMCENTDS_R WCA 124 1,000 124,000 30
FFMCENTER_R WCA 298 1,000 298,000 73
ICCNCPTLNK_R WCA 40 1,000 40,000 10
ICCONSTRNT_R WCA 67 1,000 67,000 16
ICEXPLFEAT_R WCA 70 1,000 70,000 17
ICFEATPROP_R WCA 104 1,000 104,000 25
ICKNOWDESC_R WCA 1,073 1,000 1,073,000 262
ICKNOWLEDG_R WCA 156 1,000 156,000 38
ICMETAPHOR_R WCA 434 1,000 434,000 106
ICMETAREG_R WCA 136 1,000 136,000 33
ICMREGDESC_R WCA 140 1,000 140,000 34
IITEMLIST_T WCA 48 1,000 48,000 12
IITEM_R WCA 86 1,000 86,000 21
INITIATIVE_R WCA 118 1,000 118,000 29
INTVSCHED_R WCA 68 1,000 68,000 17
ITEMSPC_R WCA 131 1,000 131,000 32
LISTPRICE_R WCA 63 1,000 63,000 15
MBRATTR_R WCA 309 1,000 309,000 75
MBRATTRVAL_R WCA_TAB8K 32,759 1,000 32,759,000 7,998
MEMBER_R WCA 46 1,000 46,000 11
OFFERDESC_R WCA 298 1,000 298,000 73
OFFERPRICE_R WCA 83 1,000 83,000 20
OFFER_R WCA 122 1,000 122,000 30
ORDERITEMS_R WCA 244 1,000 244,000 60
ORDERS_R WCA 229 1,000 229,000 56
ORDPAYMTHD_R WCA 133 1,000 133,000 32
ORDSTAT_R WCA 78 1,000 78,000 19
ORGENTITY_R WCA 3,585 1,000 3,585,000 875
PARTICIPNT_R WCA 68 1,000 68,000 17
PASTATS_R WCA 52 1,000 52,000 13
PCSTATS_R WCA 52 1,000 52,000 13
PESTATS_R WCA 52 1,000 52,000 13
QTYUNITDSC_R WCA 305 1,000 305,000 74
RFQPROD_R WCA 95 1,000 95,000 23
RFQ_R WCA 340 1,000 340,000 83
RFQRSPPRD_R WCA 103 1,000 103,000 25
RFQRSP_R WCA 1,052 1,000 1,052,000 257
SASTATS_R WCA 56 1,000 56,000 14
SHIPMODE_R WCA 100 1,000 100,000 24
STADDRESS_R WCA 420 1,000 420,000 103
STOREENTDS_R WCA 124 1,000 124,000 30
STOREENT_R WCA 48 1,000 48,000 12
STORELANG_R WCA 43 1,000 43,000 10
STORE_R WCA 55 1,000 55,000 13
TRADING_R WCA 80 1,000 80,000 20
TRDDEPAMT_R WCA 86 1,000 86,000 21
TRDREFAMT_R WCA 70 1,000 70,000 17
TRDTYPEDSC_R WCA_TAB8K 32,740 1,000 32,740,000 7,993
USERDEMO_R WCA 449 1,000 449,000 110
USERPROF_R WCA 421 1,000 421,000 103
USERS_R WCA 103 1,000 103,000 25
USRTRAFFIC_R WCA_TAB8K 99,303 1,000 99,303,000 24,244
WTAXINFO_R WCA 69 1,000 69,000 17

Tables in IWHWSA schema

BROWSERS WCA 301 0 0 1
CALENDAR WCA 99 0 0 1
COOKIESSTATUS WCA 101 0 0 1
DOMAIN WCA 101 0 0 1
HIT_FACTS WCA 373 0 0 1
HITPARMS WCA 67 0 0 1
IMPORTHISTORY WCA 57 0 0 1
JAVASCRIPTSTATUS WCA 101 0 0 1
KEY WCA 301 0 0 1
NETWORKS WCA 117 0 0 1
PARMS WCA 313 0 0 1
PLATFORMS WCA 301 0 0 1
PROTOCOLS WCA 101 0 0 1
REFERRER WCA 67 0 0 1
REFERRERHOST WCA 305 0 0 1
REFERRERURL WCA 301 0 0 1
RESOURCES WCA 313 0 0 1
RESULT WCA 293 0 0 1
RETURNCODES WCA 151 0 0 1
SERVERNODES WCA 51 0 0 1
SERVERS WCA 301 0 0 1
SESSION_FACTS WCA 269 0 0 1
SESSIONPARMS WCA 63 0 0 1
SUBDOMAINS WCA 309 0 0 1
TIMEOFDAY WCA 67 0 0 1
USERAGENTS WCA 317 0 0 1
USERS WCA 309 0 0 1
VALUE WCA 301 0 0 1
WEB_NODES WCA 297 0 0 1

Tables in WCA schema

ACCOUNT WCA _ACCOUNT 262 1,000 262,000 64
ADDRESS WCA _ADDRESS 1,947 1,000 1,947,000 475
ATTRIBUTE WCA _ATTRIBUTE 348 1,000 348,000 85
ATTRIBUTE_BIN WCA _ATTRIBUTE_BIN 206 1,000 206,000 50
BASEITEM WCA _BASEITEM 132 1,000 132,000 32
CAMP_INIT_MPE_REL WCA _CAMP_REL 34 1,000 34,000 8
CONTRACT WCA _CONTRACT 300 1,000 300,000 73
ACCT_STATUS_REF WCA _DATA 118 1,000 118,000 29
ADDRESS_TYPE_REF WCA _DATA 59 1,000 59,000 14
AGE_RANGE_REF WCA _DATA 106 1,000 106,000 26
ALL_STORES_PARAM WCA _DATA 11 1,000 11,000 3
APPLY_INIT WCA _DATA 54 1,000 54,000 13
APPLY_MEMBER WCA _DATA 70 1,000 70,000 17
APPLY_RESULT WCA _DATA 62 1,000 62,000 15
APV_STATUS_REF WCA _DATA 59 1,000 59,000 14
BROWSER WCA _DATA 272 1,000 272,000 66
BUYERPOTYP_REF WCA _DATA 91 1,000 91,000 22
CAMPAIGN WCA _DATA 416 1,000 416,000 102
CATALOG WCA _DATA 276 1,000 276,000 67
CATALOG_REF WCA _DATA 534 1,000 534,000 130
CATEGORY_REF WCA _DATA 534 1,000 534,000 130
CONCEPT_HIERARCHY WCA _DATA 30 1,000 30,000 7
CONCEPT_REF WCA _DATA 654 1,000 654,000 160
CON_STATUS_REF WCA _DATA 214 1,000 214,000 52
CONSTRAINTS WCA _DATA 57 1,000 57,000 14
CUR_CONVERT_HIST WCA _DATA 60 1,000 60,000 15
CURRENCYCONVERSION WCA _DATA 60 1,000 60,000 15
DAY_OF_FM_REF WCA _DATA 62 1,000 62,000 15
DAY_OF_FY_REF WCA _DATA 62 1,000 62,000 15
DAY_OF_WK_REF WCA _DATA 62 1,000 62,000 15
DAY_RANGE_REF WCA _DATA 308 1,000 308,000 75
DR_MEMBER_TYPE_REF WCA _DATA 37 1,000 37,000 9
EVENT_TYPE_REF WCA _DATA 77 1,000 77,000 19
FACT_CPGN_STATS WCA _DATA 62 1,000 62,000 15
FACT_METAPHOR WCA _DATA 110 1,000 110,000 27
FEATURES WCA _DATA 52 1,000 52,000 13
FFMCENTER WCA _DATA 620 1,000 620,000 151
HOUR WCA _DATA 34 1,000 34,000 8
HOUR_AMPM_REF WCA _DATA 64 1,000 64,000 16
HOUR_TYPE_REF WCA _DATA 404 1,000 404,000 99
INCOME_REF WCA _DATA 406 1,000 406,000 99
INITIATIVE WCA _DATA 179 1,000 179,000 44
INVNTRY_STAT_REF WCA _DATA 90 1,000 90,000 22
LANGUAGE_REF WCA _DATA 22 1,000 22,000 5
LAST_UPDATED_REF WCA _DATA 28 1,000 28,000 7
MARITAL_STAT_REF WCA _DATA 59 1,000 59,000 14
MEMBER_TYPE_REF WCA _DATA 57 1,000 57,000 14
META_FEAT_REL WCA _DATA 90 1,000 90,000 22
METAPHOR WCA _DATA 424 1,000 424,000 104
METAPHOR_TYPE_REF WCA _DATA 122 1,000 122,000 30
MON_OF_FY_REF WCA _DATA 62 1,000 62,000 15
MPE_TYPE_REF WCA _DATA 340 1,000 340,000 83
MPF_TYPE_REF WCA _DATA 59 1,000 59,000 14
ORDER_STATUS_REF WCA _DATA 151 1,000 151,000 37
ORGANIZATION WCA _DATA 2,815 1,000 2,815,000 687
ORIGIN_REF WCA _DATA 92 1,000 92,000 22
PARAMETERS WCA _DATA 82 1,000 82,000 20
PARTROLE_REF WCA _DATA 136 1,000 136,000 33
PER_AGGR_REF WCA _DATA 62 1,000 62,000 15
PER_DESC_REF WCA _DATA 202 1,000 202,000 49
PRODUCT WCA _DATA 367 1,000 367,000 90
QTR_OF_FY_REF WCA _DATA 62 1,000 62,000 15
RANK_RANGE_REF WCA _DATA 308 1,000 308,000 75
REFERENCE WCA _DATA 340 1,000 340,000 83
RFQ_ENDRES_REF WCA _DATA 59 1,000 59,000 14
RFQ_STATUS_REF WCA _DATA 59 1,000 59,000 14
RSP_STATUS_REF WCA _DATA 96 1,000 96,000 23
SEG_ATTRIBUTE_REF WCA _DATA 368 1,000 368,000 90
SEGMENT WCA _DATA 360 1,000 360,000 88
SEGMENTATION WCA _DATA 364 1,000 364,000 89
SHIPMODE WCA _DATA 82 1,000 82,000 20
STORE WCA _DATA 66 1,000 66,000 16
STORE_REF WCA _DATA 486 1,000 486,000 119
TRADETYPE_REF WCA _DATA 106 1,000 106,000 26
TRD_STATUS_REF WCA _DATA 92 1,000 92,000 22
WK_OF_FM_REF WCA _DATA 64 1,000 64,000 16
WK_OF_FQ_REF WCA _DATA 64 1,000 64,000 16
WK_OF_FY_REF WCA _DATA 64 1,000 64,000 16
FACT_EVENT WCA _FACT_EVENT 98,695 1,000 98,695,000 24,095
FACT_PA WCA _FACT_META 50 1,000 50,000 12
FACT_PC WCA _FACT_META 58 1,000 58,000 14
FACT_PE WCA _FACT_META 50 1,000 50,000 12
FACT_SA WCA _FACT_META 54 1,000 54,000 13
FACT_VISITS WCA _FACT_VISIT 98,572 1,000 98,572,000 24,065
FACT_INTEREST WCA _FT_INT_ATTR 128 1,000 128,000 31
FACT_INTEREST_LIST WCA _FT_INT_LIST 99 1,000 99,000 24
ITEMSPC WCA _ITEMSPC 113 1,000 113,000 28
MEMBER WCA _MEMBER 1,694 1,000 1,694,000 414
MPE WCA _MPE 344 1,000 344,000 84
OFFER WCA _OFFER 121 1,000 121,000 30
OFFER_DESC WCA _OFFERDESC 280 1,000 280,000 68
OFFER_PRICE WCA _OFFERPRICE 45 1,000 45,000 11
FACT_ORDERITEMS WCA _ORDERITEM 701 1,000 701,000 171
FACT_ORDERS WCA _ORDERS 612 1,000 612,000 149
PARTICIPNT WCA _PARTICIPNT 54 1,000 54,000 13
PERIOD WCA _PERIOD 106 1,000 106,000 26
GENDER_REF WCA _PROD_ATTR 62 1,000 62,000 15
PROD_ATTR_REF WCA _PROD_ATTR 788 1,000 788,000 192
PRODUCT_ATTRIBUTE WCA _PROD_ATTR 30 1,000 30,000 7
PRODUCT_REF WCA _PRODDESC 348 1,000 348,000 85
PRODUCT_HIERARCHY WCA _PRODHIER 356 1,000 356,000 87
RFM WCA _RFM 90 1,000 90,000 22
RFM_ATTR_LIST WCA _RFMATTR 318 1,000 318,000 78
RFM_MEMBER WCA _RFMMBR 332 1,000 332,000 81
RFM_TRADING WCA _RFMTRAD 352 1,000 352,000 86
RFQ WCA _RFQ 322 1,000 322,000 79
RFQ_REQPRD WCA _RFQREQPRD 77 1,000 77,000 19
RFQ_RSP WCA _RFQRSP 1,034 1,000 1,034,000 252
RFQ_RSPPRD WCA _RFQRSPPRD 85 1,000 85,000 21
SUM_MEMBER WCA _SUMMBR 67 1,000 67,000 16
SUM_TRADING WCA _SUMTRAD 67 1,000 67,000 16
TRADING WCA _TRADING 62 1,000 62,000 15
EMSPOT 340 1,000 340,000 83
MEMBER_ORDERS 12 1,000 12,000 3
MEMBER_WISHES 12 1,000 12,000 3
RESULTTYPE_REF 340 1,000 340,000 83

Tables in WCAETL schema

BROWSER1_INFO WCA 245 1,000 245,000 60
BUYERPO_PAYMTHD WCA 35 1,000 35,000 9
CAMP_PERIOD WCA 26 1,000 26,000 6
CURR_CONV WCA 18 1,000 18,000 4
DMT_MEMBER_T WCA 16 1,000 16,000 4
FE_CLICKS_T WCA 62 1,000 62,000 15
FE_FOI_T WCA 105 1,000 105,000 26
FE_REFURL_T WCA 148 1,000 148,000 36
FE_UPDS_T WCA 101 1,000 101,000 25
FM_FOI_T WCA 82 1,000 82,000 20
FM_UPDATE_T WCA 34 1,000 34,000 8
FM_UPDS_T WCA 66 1,000 66,000 16
FO_OITEM_T WCA 107 1,000 107,000 26
ORD_CREATE_DATE WCA 34 1,000 34,000 8
ORDER_CURRENCY_REF WCA 11 1,000 11,000 3
ORDERITEM_OFFER WCA 47 1,000 47,000 11
ORDERITEMS_TRADING WCA 36 1,000 36,000 9
REPLICATION_HISTORY WCA 66 1,000 66,000 16
RPT_MEMBER_T WCA 16 1,000 16,000 4
TEM_CURRENCYCON WCA 60 1,000 60,000 15
TMP_SUM WCA 24 1,000 24,000 6
T_ORDERS_PER_HOUR WCA 26 1,000 26,000 6
WebSphere Commerce Analyzer _TRACE WCA 202 1,000 202,000 49
AGE_V 24 1,000 24,000 6
DMT_PROSPECT_V 36 1,000 36,000 9
DMT_PURCHASER_V 36 1,000 36,000 9
FE_ORD_STATUS_V 36 1,000 36,000 9
FM_ORD_STATUS_V 36 1,000 36,000 9
GENDER_REF_V 14 1,000 14,000 3
INCOME_V 132 1,000 132,000 32
MARITAL_STAT_REF_V 9 1,000 9,000 2
MEMBER_TYPE_REF_V 7 1,000 7,000 2
PROSPECT_COUNT_V 12 1,000 12,000 3
PURCHASER_COUNT_V 12 1,000 12,000 3

Tables in WCAEXCPT schema

ACCOUNTSUM WCA 3,2803 0 0 1
ADDRESS WCA 3,4725 0 0 1
BASEITEM WCA 3,2910 0 0 1
CONTRACTSUM WCA 32,839 0 0 1
DMT_MEMBER_T WCA 32,794 0 0 1
FACT_EVENT WCA 131,493 0 0 1
FACT_INTEREST_LIST WCA 32,877 0 0 1
FACT_METAPHOR WCA 32,888 0 0 1
FACT_ORDERS WCA 33,390 0 0 1
FACT_ORDERITEMS WCA 34,116 0 0 1
FACT_VISITS WCA 131,350 0 0 1
FE_CLICKS_T WCA 32,840 0 0 1
FE_FOI_T WCA 32,883 0 0 1
FE_REFURL_T WCA 32,926 0 0 1
FE_UPDS_T WCA 32,879 0 0 1
FM_FOI_T WCA 32,860 0 0 1
FM_UPDATE_T WCA 32,812 0 0 1
FM_UPDS_T WCA 32,844 0 0 1
FO_OITEM_T WCA 32,885 0 0 1
INITCHARS WCA 32,867 0 0 1
MEMBSUMS WCA 33,385 0 0 1
MEMCTGSUMT WCA 32,841 0 0 1
MEMCTGYSUM WCA 32,841 0 0 1
MEMORDSUM WCA 33,316 0 0 1
MEMPRODSUM WCA 33,327 0 0 1
PRODUCT_ATTRIBUTE WCA 32,808 0 0 1
RPT_MEMBER_T WCA 32,794 0 0 1
TMP_CALC_ITEMS WCA 32,846 0 0 1
TMP_SUM_ITEMS WCA 32,966 0 0 1
T_PERIOD_ORDER WCA 32,800 0 0 1

Tables in WCAMNG schema

ACCOUNTSUM WCA 77 1,000 77,000 19
ACNTAPP01 WCA 42 1,000 42,000 10
ACNTAPP02 WCA 42 1,000 42,000 10
APPTABS WCA 52 1,000 52,000 13
ARFQAPP01 WCA 42 1,000 42,000 10
ARFQAPP02 WCA 42 1,000 42,000 10
CNTRAPP01 WCA 42 1,000 42,000 10
CNTRAPP02 WCA 42 1,000 42,000 10
CONTRACTSUM WCA 61 1,000 61,000 15
DATATABS WCA 560 1,000 560,000 137
INITAPP11 WCA 38 1,000 38,000 9
INITAPP12 WCA 38 1,000 38,000 9
INITCHARS WCA 89 1,000 89,000 22
MEMAPP21 WCA 42 1,000 42,000 10
MEMAPP22 WCA 42 1,000 42,000 10
MEMAPP31 WCA 42 1,000 42,000 10
MEMAPP32 WCA 42 1,000 42,000 10
MEMAPP41 WCA 42 1,000 42,000 10
MEMAPP42 WCA 42 1,000 42,000 10
MEMAPP51 WCA 42 1,000 42,000 10
MEMAPP52 WCA 42 1,000 42,000 10
MEMAPP61 WCA 42 1,000 42,000 10
MEMAPP62 WCA 42 1,000 42,000 10
MEMAPP91 WCA 42 1,000 42,000 10
MEMAPP92 WCA 42 1,000 42,000 10
MEMBSUMS WCA 607 1,000 607,000 148
MEMBSUMSAMP WCA 607 1,000 607,000 148
MEMCTGSUMT WCA 63 1,000 63,000 15
MEMCTGYSAMP WCA 537 1,000 537,000 131
MEMCTGYSUM WCA 537 1,000 537,000 131
MEMORDSAMP WCA 538 1,000 538,000 131
MEMORDSUM WCA 538 1,000 538,000 131
MEMPRODSAMP WCA 549 1,000 549,000 134
MEMPRODSUM WCA 549 1,000 549,000 134
MODELS WCA 596 1,000 596,000 146
ORDAPP71 WCA 50 1,000 50,000 12
ORDAPP72 WCA 50 1,000 50,000 12
PRODAPP81 WCA 50 1,000 50,000 12
PRODAPP82 WCA 50 1,000 50,000 12
PRODAPP83 WCA 50 1,000 50,000 12
PRODAPP84 WCA 50 1,000 50,000 12

Tables in WSA schema

ADDED_TO WSA_DATA 118 4 472 1
COOKIE_STATUS WSA_DATA 72 1 72 1
HIT_FACTS WSA_HIT_FACTS 162 0 0 1
HTTP_VERSION WSA_HIT_FACTS 272 0 0 1
NAV_PATH_RANGE WSA_DATA 520 6 3,120 1
NAVIGATION_FACT WSA_NAV_FACT 2,672 0 0 1
NETWORK_SUB_DOMAIN WSA_DATA 578 1 578 1
PROTOCOLS WSA_DATA 72 1 72 1
REFERRER WSA_DATA 526 1 526 1
RESET_STATUS WSA_DATA 72 1 72 1
RESOURCE WSA_DATA 285 1 285 1
RESULT WSA_DATA 272 1 272 1
RETURN_CODE WSA_DATA 122 1 122 1
SERVER WCA 272 1 272 1
SESSION_FACTS WSA_SESS_FACTS 216 0 0 1
SRCH_CLASS WSA_DATA 208 16 3,328 1
SRCH_CLASS_FACT WSA_S_CLS_FT 376 0 0 1
SRCH_COMPOSITE_FACT WSA_S_COMP_FT 115 0 0 1
SRCH_COMPOSITE_STRING WSA_S_COMP_FT 1,022 0 0 1
SRCH_CRITERIA WSA_DATA 298 6 1,788 1
SRCH_RESULT_FACT WSA_S_RESLT_FT 149 0 0 1
SRCH_RESULT_TYPE WSA_DATA 118 4 472 1
SRCH_SCOPE WSA_DATA 118 4 472 1
USER_AGENTS WSA_DATA 786 1 786 1
WSA_PARAMETER WSA_DATA 178 0 0 1

Feedback