topic Re: database utility in Application Development and Automation Discussions

database utility

Former Member — Tue, 23 Oct 2007 02:53:17 GMT

Hi all,

Here i have changed the lenght of field in the table pa9103.

custom field only .

i try to activate but it is giving some errors

then i went to se14 and try to adjust the table but the system is saying error in step 2.

can any body help me in this regards we are using ECC 6 .

with regards

anand

Re: database utility

Former Member — Tue, 23 Oct 2007 02:58:38 GMT

Hi Anand,

Can you tell what is the error?

Regards,

Atish

Re: database utility

Former Member — Tue, 23 Oct 2007 03:21:05 GMT

Request: Convert Table PA9103 (ANANDK/22.10.07/17:14)

Process: cisdev_1

Enhancement category 3 possible, but include or subty. not yet classified

Test activation of Table PA9103 successful

Field PERF_GRADE: Type change

ALTER TABLE is not possible

Database object for table PA9103 is checked

Database object for table PA9103 is consistent

Convert Table PA9103 by unloading and reloading the data

Type of conversion: T -> T

Begin step PA9103-STEP1:

Step is empty

Step PA9103-STEP1 executed successfully

Begin step PA9103-STEP2:

sql:

RENAME TABLE "PA9103" to "QCMPA9103"

SQL0289N Unable to allocate new pages in table space "SYSCATSPACE".

SQLSTATE=57011

DDL time(___1): .......606 milliseconds

The SQL statement was not executed

Renaming of table PA9103 to QCMPA9103 failed

Error in step PA9103-STEP2

Total time for table PA9103: 000:00:01

Request for PA9103 could not be executed

Request: Convert Table PA9103 (ANANDK/22.10.07/17:15)

Process: cisdev_1

Enhancement category 3 possible, but include or subty. not yet classified

Test activation of Table PA9103 successful

A restart log already exists for table PA9103

Re: database utility

Former Member — Tue, 23 Oct 2007 03:39:22 GMT

Hi,

I guess you'll have to check with your BASIS people

Begin step PA9103-STEP2:

sql:

RENAME TABLE "PA9103" to "QCMPA9103"

SQL0289N Unable to allocate new pages in table space "SYSCATSPACE".

SQLSTATE=57011

DDL time(___1): .......606 milliseconds

The SQL statement was not executed

Renaming of table PA9103 to QCMPA9103 failed

Error in step PA9103-STEP2

The problem has more to do with system rather than the procedure you are following.

Hope this helps

Regards

Nishant

null

Re: database utility

Former Member — Tue, 23 Oct 2007 06:05:22 GMT

Hi Anand ,

From the ECC systems whenever you create a table you need to do One more step so that later on stages based on that step only it will accept your change's (or ) Restrict not to do that changes .

And i am sure that your table has Option 5 .that is why it was giving Error.

Step is se11->open your table in the Menu Extras->Enhancement Category (CLICK on it )

see the Options and Observer Which option it was Opted for your table

1.Cannot be enhanced

2.Can be enhanced or character type

3.Can be enhanced or character-type or numeric

4.Can be enhanced in any way

5.Not classified

This category can be chosen, for example, for a transition status; however, it must not be chosen for creating structures.

so Opted for the 3 one .

Reward points if it is usefull ...

Girish