Weblogics/DB2/length index names
Good suggestion, Randall. DB2 queries do not allow you to name indexes - deciding
whether to use an index and which indexes to use are the jobs of the DB2
optimizer, not the DBA, user or programmer.
Quote:
> Mike,
> Why not just define those indexes using smaller names? I doubt that
> WebLogic's queries call out indexes by name.
> On Mon, 14 Aug 2000 16:54:06 +0200 esteemed Mike Eriksen did'st hold
> forth thusly:
> > Hi
> > We got a problem with weblogic commerce server and DB2.
> > In order to use the DB2 database with weblogic we need to create a
> > tablestructure which mimics the tablestructure in the original cloudscape
> > database. The problem we came accross was that of index names which are more
> > than 18chars of length. e.g.
> > PROP_MD_BOOLEAN_INDEX
> > PROP_MD_INTEGER_INDEX
> > PROP_MD_USER_DEFINED_INDEX
> > Which are all longer that 18 chars of length.
> > These indexes are on WLCS_* tables which are all system tables which must be
> > in place for weblogiccommerce to work.
> > I cannot find any documentention regarding weblogic usertables and/or index
> > configuration.
> > Thanks
