Creating Indexes via Control Center... Error w/ Index Schema - SYSIBM

[fletchsod]

I had determined only 4 indexes need to be made. So, I went to the Control Center to manually add the first index.

I noticed those tables that were created with primary key use the "SYSIBM" Index Schema. So, I figured I can do the same when I manually add an index and I used that Index Schema and got error saying I can't use that Index Schema. I saw that I have a choice of using 5 other Index Schema which are 1) DB2INST1, NULLID, SYSCAT, SYSFUN, SYSSTAT.

I'm not familiar with those and what those can do. So, any advice or suggestion on which should I use?

Thanks...

 

[blom0344]

If you check on the tables you are going to index. Under which schema are those created?

Ties Blom

 

[fletchsod]

How do I tell that? (Which schema was created upon the creation of the tables).

Thanks...

 

[blom0344]

Do not have a running instance of DB2 to check, but I always used the sysibm.systables like:

select name,creator from sysibm.systables where name = << fill in name>> and type = 'T'

you can also use a CLP command like (once you find the schema):

LIST TABLES FOR SCHEMA <schema_name>

Basically, if you create a table as user 'target' , then DB2 will automatically assume that it's schema is 'target'



Ties Blom