Archives of the TeradataForum

Message Posted: Fri, 11 Aug 2006 @ 09:49:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All

We are not able to drop some of the tables in one of our database . If we are trying to drop the tables, we are seeing the explain plan in teradata manager (session information) not progressing past step1. The drop table never completes, but seems to go into an infinite loop, thus not returning a success or error:

Pl check bellow Explain flan in Session Information on Tearadata Manager

     1    0:00.00    0    First, lock mds."pseudo table" for exclusive on a row hash.

     2    0:00.00    0    Next, we lock mds.metarelation_200 for exclusive.

     3    0:00.00    0    We lock DBC."pseudo table" for write on a row hash, we lock
                             DBC."pseudo table" for read on a row hash, we lock
                             DBC."pseudo table" for write on a row hash and we lock
                             DBC."pseudo table" for write on a row hash.

     4    0:00.00    0    We lock DBC.TVM for write on a row hash, we lock
                             DBC.[TBId=0x0094] for write on a row hash, we lock
                             DBC.DBase for read on a row hash, we lock DBC.TVFields
                             for write on a row hash, we lock DBC.AccessRights for
                             write on a row hash, we lock DBC.DBCAssociation for write
                             on a row hash and we lock DBC.Indexes for write on a
                             row hash.

     5    0:00.00    0    We do a Single-AMP ABORT test from DBC.DBase by way of the
                             unique primary index. This step begins a parallel block
                             of steps.

     5    0:00.00    0    We do a Single-AMP ABORT test from DBC.TVM by way of the
                             unique primary index. This step is performed in parallel.

     5    0:00.00    0    We do a Single-AMP ABORT test from DBC.TVM by way of the
                             unique primary index. This step is performed in parallel.

     5    0:00.00    0    We do a Single-AMP DELETE step from DBC.TVFields by way of
                             the primary index. This step is performed in parallel.

     5    0:00.00    0    We do a Single-AMP DELETE step from DBC.Indexes by way of
                             the primary index. This step is performed in parallel.

     5    0:00.00    0    We do a Single-AMP DELETE step from DBC.DBCAssociation by
                             way of the primary index. This step is performed in
                        parallel.

     5    0:00.00    0    We do a Single-AMP DELETE step from DBC.TVM by way of the
                             unique primary index. This step is performed in parallel.

     5    0:00.00    0    We do a Single-AMP DELETE step from DBC.AccessRights by way
                             of the primary index. This step is performed in parallel.

     5    0:00.00    0    We do a Single-AMP DELETE step from DBC.[TBId=0x0094] by way
                             of the primary index. This step ends a parallel block of
                             steps.

     6    0:00.00    0    We drop the table header and the data in the table
                             metarelation_200.

     7    0:00.00    0    We Spoil the parser's dictionary cache for the table.

     8    0:00.00    0    We send out an END TRANSACTION step to all AMPs involved in
                             processing the request.

We would be grateful if anyone can help us with the above subject.

Regards,

Rao

	<Prev	Next>		<<First	<Prev	Next>	Last>>