I am a DB2 novice and cannot understand the concept when people in my team say that dropping a primary index on db2 table will cause damage to the data.Is it really true ? I know we can do a drop/alter a primary index on an oracle or sybase table.

DB2 requires that a unique index exist on the primary key. If a unique index does not already exist when the PK is defined, then DB2 will create one for you. If one already exists, then DB2 will use it.

Some other databases may just do a table scan making sure there are no duplicates if no unique index exists on the PK, but DB2 always uses the unique index to do make sure there are no duplicates.

You can drop the index if you first remove the PK.