(Created page with "= Verify Indexes= {{#dpl: |namespace=Documentation |titlematch=%GIM:Library:Table-SDR% |resultsheader=There are %PAGES% SDR tables |include= |mode=userformat }} of whic...") |
|||
| Line 1: | Line 1: | ||
| − | = Verify | + | = Verify Content= |
| + | ==Verify Indexes== | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| Line 58: | Line 59: | ||
}}</li> | }}</li> | ||
</ul> | </ul> | ||
| + | |||
| + | ==Verify Primary Keys== | ||
| + | Mykola's tool populates the {{!}}primaryKey parameter based on the partitioned SQL script, which means START_DATE_TIME_KEY is shown as a primary key. This parameter must be cleared manually, since we have elected to show the nonpartitioned settings in the Column List tables. Use the following DPL to verify that unwanted {{!}}primaryKey = yes settings have been cleared. | ||
| + | |||
| + | {{#dpl: | ||
| + | |namespace=Documentation | ||
| + | |titlematch=GIM:Library:Table-%:{{PONYDOCSVERSION}}% | ||
| + | |uses=Template:PDMColumn | ||
| + | |includematch=/colName\s*=\s*START_DATE_TIME_KEY/ | ||
| + | |include={PDMColumn}:primaryKey | ||
| + | |resultsheader=Value of the primaryKey parameter on the following table(s): | ||
| + | |noresultsheader=No START_DATE_TIME_KEY columns have a populated primaryKey parameter. | ||
| + | |format=,\n [[%PAGE%]] - ,, | ||
| + | |mode=userformat | ||
| + | }} | ||
| + | |||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] | ||
Revision as of 14:49, June 8, 2016
Verify Content
Verify Indexes
There are 154 SDR tables of which 0 do not have indexes.
Of the 154 tables that have indexes:
- All indexes are present in partitioned (no indexPresentInPartitioned=no).All indexes are present in partitioned (no indexPresentInPartitioned=no).
- All indexes have keyPresentInNonpartitioned on the page.All indexes have keyPresentInNonpartitioned on the page.
- All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).
Verify Primary Keys
Mykola's tool populates the |primaryKey parameter based on the partitioned SQL script, which means START_DATE_TIME_KEY is shown as a primary key. This parameter must be cleared manually, since we have elected to show the nonpartitioned settings in the Column List tables. Use the following DPL to verify that unwanted |primaryKey = yes settings have been cleared.
Value of the primaryKey parameter on the following table(s):
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CDR FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CHAT THREAD FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-LDR FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT - yes
Comments or questions about this documentation? Contact us for support!