DB2 DATABASES STATUS - 09-24-99
DATABASES/ TABLES/ APPLICATION
FINANCED -- 23 (PEOPLE SOFT)
GLEDGERD- 69 (FIS)
HUMANRSD- 42 (HUMAN RESOURCES)
LABDISTD - 102 (FIS)
SHAREDBD - 7 (FIS,Card Services,HR, IU ACCOUNTS)
STUDCWKD- 29 (Student Records)
STUDENTD - 26 (FAMS TOUCHTONE, Student Loans/Bars/FIS/FDRS, UNIVERSAL USER ID,IUPUI Testing Center(pl
(Course Inventory, SIS for Acadenic Structure , Course Offering, GradPact)
TOTAL= 298
SER ID,IUPUI Testing Center(pltestt)
Database FINANCED CREATOR TABLESPACE
ADRSTATT PRODDBA FIADRSTS
BILLFRQT PRODDBA FIBLFRQS
BORROWRT PRODDBA FIBORWRS
CG_AGENCY_RPT_NM_T PRODDBA CGAGNCYS
CG_AWD_ACCT_T PRODDBA CGAWDACS
CG_AWD_STD_RPT_T PRODDBA CGAWARDS
CG_LTRCR_FNDGRP_T PRODDBA CGLFGRPS
CGACEXCT PRODDBA FICGAEXS
COSIGNRT PRODDBA FICSGNRS
EISTTRPT PRODDBA EISTTRPS
EOSTACNT PRODDBA EOSTACNS
FIRPTGPT PRODDBA FIRPTGPS
FS_BNK_T PRODDBA FSBANKS
FS_CUST_BNK_T PRODDBA FSCSTBKS
LOANFNDT PRODDBA FILNFNDS
LOANSTAT PRODDBA FILNSTTS
LOANT PRODDBA FILOANS
LOANTYPT PRODDBA FILNTYPS
PRPSUBCT PRODDBA FIPRSBTS
RPDTEXCT PRODDBA FIRPDEXS
RPTLEXCT PRODDBA FIRPLEXS
TRAVSECT PRODDBA TRAVSECS
ROWS
11
4
53,064
2,350
20,595
48,928
30
0
0
0
0
1,070
26,925
34
35
6
91,508
116
218
0
0
317
Database GLEDGERD CREATOR TABLESPACE
CA_ACCOUNT_T PRODDBA CAACCTS
CA_ACCOUNT_TYPE_T PRODDBA CAATYPS
CA_ACCT_DELEGATE_T PRODDBA CAADELS
CA_ACCT_DESC_T PRODDBA CAADESS
CA_ACCT_GDLNPRPS_T PRODDBA CAAGDLS
CA_ACCT_PERSON_T PRODDBA CAACBPS
CA_AICPA_FUNC_T PRODDBA CAAFUNS
CA_A21_SUB_ACCT_T PRODDBA CAA21SAS
CA_BALANCE_TYPE_T PRODDBA CABTYPS
CA_CHART_HIER_T PRODDBA CACOAHS
CA_CHART_T PRODDBA CACOATS
CA_FEDERAL_FUNC_T PRODDBA CAFFUNS
CA_FUND_GRP_T PRODDBA CAFGRPS
CA_HIGHR_ED_FUNC_T PRODDBA CAHEFNS
CA_ICR_AUTO_ENTR_T PRODDBA CAICRES
CA_ICR_EXCL_ACCT_T PRODDBA CAICRAS
CA_ICR_EXCL_TYPE_T PRODDBA CAICRTS
CA_ICR_THRESHOLD_T PRODDBA CAITHRS
CA_ICR_TYPE_T PRODDBA CAITYPS
CA_OBJ_CONSOLDTN_T PRODDBA CAOBJCS
CA_OBJ_LEVEL_T PRODDBA CAOBJLS
CA_OBJ_SUB_TYPE_T PRODDBA CAOSTYS
CA_OBJ_TYPE_T PRODDBA CAOTYPS
CA_OBJECT_CODE_T PRODDBA CAOBJTS
CA_ORG_GENERATN_T PRODDBA CAORGGS
CA_ORG_HIERARCHY_T PRODDBA CAORGHS
CA_ORG_REVERSION_T PRODDBA CAOREVS
CA_ORG_T PRODDBA CAORGNS
CA_ORG_TYPE_T PRODDBA CAORTYS
CA_PRIOR_YR_ACCT_T PRODDBA CAPYACTS
CA_PRIOR_YR_ORG_T PRODDBA CAPYORGS
CA_PROJECT_T PRODDBA CAPROJS
CA_RC_T PRODDBA CARCENS
CA_REORG_XREF_T PRODDBA CARORGS
CA_RESTRICT_STAT_T PRODDBA CARSTAS
CA_SUB_ACCT_T PRODDBA CASACCS
CA_SUB_FUND_GRP_T PRODDBA CASFGRS
CA_SUB_OBJECT_CD_T PRODDBA CASOBJS
CA_UBO_FUNC_T PRODDBA CAUFUNS
DS_GL_EXTRT_T PRODDBA DSGLEXS
FP_CR_CARD_VNDR_T PRODDBA FPCRDVNS
FP_DOC_TYPE_T PRODDBA FPDTYPS
FP_FIS_USER_T PRODDBA FPFISUS
FS_OPTION_T PRODDBA FSSOPTS
FS_ORIGIN_CODE_T PRODDBA FSORIGS
GL_ACCT_BALANCES_T PRODDBA GLACBLS
GL_BALANCE_T PRODDBA GLGLBLS
FS_OPTION_T PRODDBA FSSOPTS
FS_ORIGIN_CODE_T PRODDBA FSORIGS
GL_ACCT_BALANCES_T PRODDBA GLACBLS
GL_BALANCE_T PRODDBA GLGLBLS
GL_ENCUMBRANCE_T PRODDBA GLGLECS
GL_ENTRY_T PRODDBA GLGLENS
GL_ERROR_T PRODDBA GLGLERS
GL_EXPEND_TRN_T PRODDBA GLGLEXS
GL_LEDGER_DATES_T PRODDBA GLLDATS
GL_OFFSET_DEFN_T PRODDBA GLOFSDS
GL_RESTRT_RECOVR_T PRODDBA GLGLRRS
GL_REVERSAL_T PRODDBA GLGLRVS
GL_RVS_ACCT_XREF_T PRODDBA GLRAXRS
GL_SF_BALANCES_T PRODDBA GLSFBLS
GL_SF_REBUILD_T PRODDBA GLSFRBS
GL_TP_EXTRACT_T PRODDBA GLTPEXS
SH_ACCT_PERIOD_T PRODDBA SHAPRDS
SH_CAMPUS_T PRODDBA SHCMPSS
SH_STATE_T PRODDBA SHSTATS
SH_UNIV_DATE_T PRODDBA SHUDATS
SH_ZIP_CODE_T PRODDBA SHZIPCS
ROWS
31,623
18
120,799
774
29,082
35
10
6,465
15
0
13
11
11
29
1,976
0
1,468
3
23
247
1,017
54
11
142,880
0
0
3,012
2,571
6
30,944
2,561
845
65
0
4
6,512
165
14,250
22
1
203
362
5,931
10
9
1,942,486
3,944,395
10
9
1,942,486
3,944,395
773,885
29,853,646
2,455
0
4
7,095
0
2,003
0
223,332
6,221
9
146
11
53
3,288
202
Database HUMANRSD CREATOR TABLESPACE
ACLEAVET PRODDBA HUALEAVS
ACTITLET PRODDBA HUATITLS
ADDRESST PRODDBA HUADDRSS
ADRSUFXT PRODDBA HUADRSFS
BANKT PRODDBA HUBANKS
BONDT PRODDBA HUBONDS
CURPAFST PRODDBA HUCURPAS
DEGREET PRODDBA HUDEGRES
DOLLARPT PRODDBA HUDOLAPS
DOLLARST PRODDBA HUDOLARS
EMPLOYRT PRODDBA HUEMPLRS
EXPERIT PRODDBA HUEXPERS
GTNT PRODDBA HUGTNS
HCDEPNDT PRODDBA HUDEPNDS
HCDEPNDT_ET PRODDBA ETDEPNDS
HONORST PRODDBA HUHONORS
HOURST PRODDBA HUHOURSS
IMMUNRT PRODDBA HUIMMRTS
IMMUNTT PRODDBA HUIMMTTS
IMMUNVT PRODDBA HUIMMVTS
INCPLANT PRODDBA HUINCPLS
INCTYPET PRODDBA HUINCTPS
INSURET PRODDBA HUINSURS
I9STATST PRODDBA HUI9STAS
LANGUAGT PRODDBA HULANGUS
LICENSET PRODDBA HULICENS
OFFADDRT PRODDBA HUOFFADS
PAFT PRODDBA HUPAFS
PARENTT PRODDBA HUPARNTS
PAYROLLT PRODDBA HUPAYROS
PERSBIOT PRODDBA HUPERSBS
PERSONT PRODDBA HUPERSOS
RETIRET PRODDBA HURETIRS
SERVICET PRODDBA HUSERVIS
SKILLST PRODDBA HUSKILLS
SOFT PRODDBA HUSOFS
SPOUSET PRODDBA HUSPOUSS
TAXEST PRODDBA HUTAXESS
TENURET PRODDBA HUTENURS
USERT PRODDBA HUUSERTS
W2T PRODDBA HUW2S
ROWS
12,866
209,373
111,591
4
84,797
7,714
232,499
87,428
61,870
51,632
31,965
11,032
904,090
28,665
0
1,117
192,664
0
0
0
4
3
232,499
113,229
59
348
94,309
1,467,042
11,741
232,499
232,499
232,499
232,499
232,497
7,583
1,686,944
4
232,499
62,119
8,722
232,499
Database LABDISTD CREATOR TABLESPACE
LD_ACAD_APPT_T PRODDBA LDACAPS
LD_APPT_EXTRCT_T PRODDBA LDAEXTS
LD_APPT_FUND_T PRODDBA LDAPFNS
LD_APPT_LEAVE_T PRODDBA LDAPLVS
LD_APPT_TYPE_T PRODDBA LDAPTYS
LD_APPTFNDAPPRVL_T PRODDBA LDAPFAS
LD_AREACOORD_LOC_T PRODDBA LDAACLS
LD_A21_DEAN_RANK_T PRODDBA LDADRKS
LD_A21_DETAIL_LN_T PRODDBA LDADLNS
LD_A21_DETAIL_T PRODDBA LDADTLS
LD_A21_DTL_DFLT_T PRODDBA LDADDFS
LD_A21_PRD_STAT_T PRODDBA LDARPSS
LD_A21_REPORT_T PRODDBA LDARPTS
LD_A21_RPT_PRD_T PRODDBA LDARPES
LD_A21_RPT_TYP_T PRODDBA LDARTYS
LD_A21_TEN_PAY_T PRODDBA LDATNPS
LD_A21AREA_COORD_T PRODDBA LDAACOS
LD_BCN_AF_LOAD_T PRODDBA LDAFLDS
LD_BCN_CSF_TRCKR_T PRODDBA LDBCSFS
LD_BCN_POS_T PRODDBA LDBCPSS
LD_BCNSTR_GL_T PRODDBA LDBCGLS
LD_BENEFITS_CALC_T PRODDBA LDBCALS
LD_BENEFITS_TYPE_T PRODDBA LDBENTS
LD_CAREERPTH_JOB_T PRODDBA LDCPJBS
LD_CAREERPTH_POS_T PRODDBA LDCPPOS
LD_CENSUS_GRP_T PRODDBA LDCENGS
LD_COST_SHARING_T PRODDBA LDCSHAS
LD_CRRPTHPOS_LOG_T PRODDBA LDCPPLS
LD_CSF_FNDSTATUS_T PRODDBA LDCFNSS
LD_CSF_TRACKER_T PRODDBA LDCSFTS
LD_CSFTRCKR_OVRD_T PRODDBA LDCSFOS
LD_CSTMTTL_CTGRY_T PRODDBA LDCUTGS
LD_CUSTOM_TITLE_T PRODDBA LDCUTIS
LD_DUR_CALENDAR_T PRODDBA LDDCALS
LD_DURATION_T PRODDBA LDDURAS
LD_EEO_JOB_CTGRY_T PRODDBA LDEEOJS
LD_FILL_IN_POS_T PRODDBA LDFLIPS
LD_HIST_JOB_NBR_T PRODDBA LDHJOBS
LD_HIST_POS_LOG_T PRODDBA LDHPSLS
LD_HIST_POS_NBR_T PRODDBA LDHPOSS
LD_JOB_CENSUS_T PRODDBA LDCENCS
LD_JOB_CLSIF_T PRODDBA LDJBCLS
LD_JOB_RANK_T PRODDBA LDJRNKS
LD_JOB_SLRY_RNG_T PRODDBA LDJSLRS
LD_JOB_STATUS_T PRODDBA LDJBSTS
LD_JOB_SUM_T PRODDBA LDJBSMS
LD_JOB_T PRODDBA LDJOBTS
LD_JOB_TYPE_T PRODDBA LDJTYPS
LD_JOBDFLT_OBJCD_T PRODDBA LDJDOBS
LD_JOBFMLY_CTGRY_T PRODDBA LDJFMSS
LD_JOBSLRYRNG_CD_T PRODDBA LDJSRCS
LD_JULY1_POS_FND_T PRODDBA LDJPSFS
LD_LABOR_OBJ_T PRODDBA LDLOBJS
LD_LBR_GL_ENTRY_T PRODDBA LDLGLNS
LD_LBR_OBJ_BENE_T PRODDBA LDLOBNS
LD_LDGR_BAL_DEL_T PRODDBA LDLLBDS
LD_LDGR_BAL_T PRODDBA LDLLBLS
LD_LDGR_ENTR_T PRODDBA LDLLENS
LD_LV_POSOBJ_PAY_T PRODDBA LDLPOPS
LD_JULY1_POS_FND_T PRODDBA LDJPSFS
LD_LABOR_OBJ_T PRODDBA LDLOBJS
LD_LBR_GL_ENTRY_T PRODDBA LDLGLNS
LD_LBR_OBJ_BENE_T PRODDBA LDLOBNS
LD_LDGR_BAL_DEL_T PRODDBA LDLLBDS
LD_LDGR_BAL_T PRODDBA LDLLBLS
LD_LDGR_ENTR_T PRODDBA LDLLENS
LD_LV_POSOBJ_PAY_T PRODDBA LDLPOPS
LD_NXT_JOB_NBR_T PRODDBA LDNJOBS
LD_NXT_LBR_CTRL_T PRODDBA LDNLBRS
LD_ORG_POS_TYP_T PRODDBA LDORPTS
LD_PAY_RT_T PRODDBA LDPYRTS
LD_PNDBC_APPTFND_T PRODDBA LDBCAFS
LD_PNDBCN_POSFND_T PRODDBA LDBCPFS
LD_PNDBCNSTRAPPT_T PRODDBA LDBCAPS
LD_POS_ACTION_T PRODDBA LDPACTS
LD_POS_BDGT_T PRODDBA LDPBDGS
LD_POS_BRGN_UNIT_T PRODDBA LDPBUNS
LD_POS_FED_RSRCH_T PRODDBA LDPFRTS
LD_POS_HIST_T PRODDBA LDPHSTS
LD_POS_OBJ_GRP_T PRODDBA LDPOGRS
LD_POS_SBTCL_T PRODDBA LDPSELS
LD_POS_STATUS_T PRODDBA LDPSTAS
LD_POS_TNR_ELIG_T PRODDBA LDPTELS
LD_POS_TYPE_T PRODDBA LDPTYPS
LD_POSITION_T PRODDBA LDPOSIS
LD_POSOBJ_PAYPRD_T PRODDBA LDPOPPS
LD_RESTRT_RECOVR_T PRODDBA LDLLRRS
LD_RLTD_POS_T PRODDBA LDRLPOS
LD_RPT_TO_POS_T PRODDBA LDRPOSS
LD_RPT_TO_POSLOG_T PRODDBA LDRPSLS
LD_SHIFT_T PRODDBA LDSHFTS
LD_SPRVSRY_CODE_T PRODDBA LDSPRVS
LD_SPVSR_LVL_T PRODDBA LDSPLVS
LD_TEMP_APPT_T PRODDBA LDTAPPS
PY_EARN_TYPE_T PRODDBA PYETYPS
PY_PAY_CYCLE_T PRODDBA PYPCYCS
PY_PAY_PERIOD_T PRODDBA PYPPERS
PY_PAYROLL_DATES_T PRODDBA PYPDATS
PY_PAYROLL_NBR_T PRODDBA PYPNBRS
PY_SUBACCTG_DIST_T PRODDBA PYSACDS
SH_UNIV_BSNS_DAY_T PRODDBA SHUBDYS
ROWS
0
0
484,423
0
15
0
363
178
142,751
85,638
0
3
40
169
4
8,364
850
18,486
0
0
0
479
6
0
0
386
2,256
0
0
128,031
1,115
0
0
0
11
8
3
0
0
0
512
86
960
1,417
4
84
5,812
8
5,460
11
190
119,286
5,142
0
7,207
2,373
1,819,778
15,398,926
0
119,286
5,142
0
7,207
2,373
1,819,778
15,398,926
0
8
1
1
2
0
0
0
15
600
9
3
167,978
22
2
6
3
8
140,472
23
0
4
0
0
0
2
8
0
140
4
4
433
61
14,879
60
Database SHAREDBD CREATOR TABLESPACE
CAMPUST PRODDBA SHCAMPTS
PLAN_TABLE PRODDBA PLANRTAB
SH_ID_CARD_MT PRODDBA SHIDCRDS
SH_ID_TRNSLT_T PRODDBA SHIDTRNS
SH_PRSN_XREF_T PRODDBA SHPRSNXS
SH_UNVL_USER_T PRODDBA SHUNVLS
ROWS
11
117,991
85,112
409,516
403,446
236,195
Database STUDCWKD CREATOR TABLESPACE
AC_WAITLIST_T PRODDBA ACWLISTS
AC_WLST_RSLT_T PRODDBA ACWRSLTS
AC_WLST_STAT_T PRODDBA ACWSTATS
CO_CLASS_AUTH_T PRODDBA COCAUTHS
CO_CLASS_MTG_T PRODDBA COCLMTGS
CO_CRS_OFFER_T PRODDBA COCRSOFS
CO_CRS_SECT_NOTE_T PRODDBA COCRSNTS
CO_MJR_AUTH_T PRODDBA COMAUTHS
CO_SECT_INSTR_T PRODDBA COINSTRS
GP_CUR_PACT_ENR_GT PRODDBA GPCENRLS
GP_HST_PACT_ENR_GT PRODDBA GPHENRLS
GP_PACT_NOTE_GT PRODDBA GPNOTESS
GP_PACT_PGM_CHG_GT PRODDBA GPPGMCHS
HI_ACAD_CR_T PRODDBA HIACDCRS
HI_CRS_DTL_T PRODDBA HICRSDTS
HI_CWRK_NTE_T PRODDBA HICWKNTS
HI_CWRK_TTL_T PRODDBA HICWKTLS
HI_IU_CWRK_T PRODDBA HIIUCWKS
HI_NSTD_IU_CWRK_T PRODDBA HINSCWKS
HI_STU_CWRK_T PRODDBA HISTCWKS
HI_TRNFR_CWRK_T PRODDBA HITRCWKS
SE_CUR_CWRK_SUMM_T PRODDBA SECURCWS
SE_STU_SECT_T PRODDBA SESSECTS
SE_STU_USER_T PRODDBA SESUSERS
SE_STUDENT_T PRODDBA SESTDNTS
SS_CUR_ENRL_PRD_T PRODDBA SSCURENS
SS_GRD_CNT_VW_T PRODDBA SSGRDCNS
SS_SECT_GRD_CNT_GT PRODDBA SSGRDCNS
ROWS
249,095
254,942
20,265
25,898
201,241
200,999
183,601
8,506
207,446
9,040
11,417
2,114
4,708
19,033,214
891,925
674,176
5,563,135
5,146,138
2,593
5,523,814
352,652
485,563
1,746,878
566,631
390,567
1
0
72,051
Database STUDENTD CREATOR TABLESPACE
ACADYRT PRODDBA SNACYRTS
BT_PMT_T PRODDBA BTPAYMTS
CALLT PRODDBA SNCALLTS
CIBYCAMT PRODDBA BYCAMPTS
CICOHRST PRODDBA CNTHRSTS
CICOURST PRODDBA CICORSTS
CICRHRST PRODDBA CRDHRSTS
CIPREQST PRODDBA CIPREQTS
CITITLET PRODDBA CITITLTS
EBYCAMT PRODDBA EBYCAMT
ECOHRST PRODDBA ECOHRST
ECOURST PRODDBA ECOURST
ECRHRST PRODDBA ECRHRST
EPREQST PRODDBA EPREQST
ETITLET PRODDBA ETITLET
EVALUATT PRODDBA SNEVALTS
FORMREQT PRODDBA SNFORMTS
GENINFOT PRODDBA SNGIMSTS
MENUSELT PRODDBA SNMENUTS
PLTESTT PRODDBA SNPLTETS
SELDESCT PRODDBA SNDESCTS
SL_BORWR_T PRODDBA SLBORWRS
SL_LOAN_T PRODDBA SLLOANTS
SS_PGM_RESULTS_T PRODDBA SSPRSLTS
SS_PGM_RUN_T PRODDBA SSPGMRNS
ROWS
651
258,923
4,959
13
23,224
29,633
32,577
10,210
35,864
0
0
0
0
0
0
0
77
296
11,715
233,350
22
64,500
170,200
0
0