Recent content by staland

Hi JK I think you (almost) got it right, you just got the column names mixed up. SELECT REENTNDAT, CASE WHEN REENTDAT IS NULL THEN '' ELSE REPOMEN END AS REENTMEN FROM HILFSSTO.REBEW It worked fine in my own installation /Helle

If the index is corrupted you have to REBUILD it (to get the correct keys from the table) If the index 'just' need to be cleaned up, you can use REORG INDEX. If you choose REORG you can still use the table (without the index) while the REBUILD utility also uses the table.

Hi We're running DB2 v7 on z/OS So far we've had one shared mapping table for running online reorg. I'm trying to change it so we can use a temporary table for the reorg jobs - that way we can run several reorg jobs simultaneously without having different mapping tables created. But the...

Hi, I just tried to recreate your problem, but I didn't have any problems. Which error do you receive?? How does your LOAD statement look? Helle Stålander

I guess your global temp tables was created with a CREATE GLOBAL TEMPORARY TABLE statement You can read much more about created temporary tables in "DB2 SQL Reference" Helle Stålander

Hello, Try this: SELECT A.NAME,B.NAME AS PRIMKEY FROM SYSIBM.SYSTABLES A, SYSIBM.SYSCOLUMNS B WHERE A.NAME = B.TBNAME AND A.KEYCOLUMNS = B.COLNO ; Helle

I'm sorry too..... I don't know anything about running DB2 on NT, I hope someone else can help you. Helle

Hello, We're running DB2 v.7 on OS/390, have ca. 120 databases with a total of 1600GB data. We're using user-managed datasets (allocating datasets by IDCAMS) but considering to convert to DB2-managed datasets (using storage groups). (We will not convert to SMS-managed.) Here's the question: How...

Hello, I'm not sure what you mean by "online copy". If it is a copy taken with shrlevel(change), it's not really a problem. RECOVER TABLESPACE database.tablespace TOCOPY copy-dataset-name TOVOLUME vol-ser TOSEQNO ## You'll probably have to take a copy of the data...