Weblogics/DB2/length index names 
Author Message
 Weblogics/DB2/length index names

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



Fri, 31 Jan 2003 03:00:00 GMT
 Weblogics/DB2/length index names

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:

Quote:
> 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



Sun, 02 Feb 2003 03:00:00 GMT
 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



Sun, 02 Feb 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. DB2 for OS/390 stored procedure name length limitation

2. Newbie Question: Max length for DB2 database name?

3. columns names,datatypes,length and indexes !

4. index and sequence name length limit?

5. Table name length (maximum identifier length)

6. db2 index name?

7. db2 for os390 data sharing/sysplex check index dsnu715i multiple index entries

8. HELP: Finding index names in sysindexes using a column name

9. Getting the Index names and indexed columns for a schema

10. Index name not found int the Index collection ??

11. Optimizer depth - Index usage dependant on name of index

12. SQL to :- index name if column has index ?


 
Powered by phpBB® Forum Software