Hi, I am working with db2 8.2 on windows env.

I restored a database with the different name everything worked fine..but when used list table spaces why is it showing total pages = 0 for DMS tablespace??

Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 0
Useable pages = 527340
Used pages = 264
Free pages = 527076
High water mark (pages) = 264
Page size (bytes) = 4096
Extent size (pages) = 12
Prefetch size (pages) = 12
Number of containers = 1

have you faced any issue while Creating any object on this tablespace in the New Database.