Quote:
|
Originally Posted by zkajfez
...
Table name are "NT_MEMORY"
...
DB2 REORG TABLE ITMUSER."NT_Memory" USE TEMPSPACE1
...
SQL2211N The specified table does not exist.
|
Table names are case sensitive in DB2,
but DB2 will always perform an implicit upper case conversion when you don't place quotes (") around the name.
So if your table name is NT_MEMORY, you can access this table by:
select * from NT_MEMORY
and
select * from nt_memory
and
select * from "NT_MEMORY"
and
select * from Nt_MeMoRy
But not
select * from "Nt_MeMoRy"
If your table name is NT_Memory, you can access this table only by protecting the given table name from being converted to upper case by putting quotes (") around the name, only in this case, DB2 will take the string literally:
select * from "NT_Memory"
If you would try to use
select * from NT_Memory
DB2 will do an implicit UCASE of your tablename thus giving NT_MEMORY and that's a table it can not find.
So the solution to your problem is: get rid of the quotes around the table name
Code:
DB2 REORG TABLE ITMUSER.NT_Memory USE TEMPSPACE1
or even better use the correct (table) names.
Code:
DB2 REORG TABLE "ITMUSER"."NT_MEMORY" USE "TEMPSPACE1"