Search results for query: *

I have to load into part14 alone. Data on other partitions to be kept as it is. Any clue on this. How can i use the load resume option. The table space has 20partitions.

Please let me know if you have any opening for DB2 DBA

We have to invoke admin rights from user id,who was a DB2 DBA in our firm. What are the steps to be considered and how to revoke the rights from his id.

THe table got 15 partitioons. I was loading data as load with replace. I got this message at 8th partition. It is like data copy from one subsystem to the other subsystem. The table defiitions are same in both the subsytems. The partitions are defined as ENDING AT...

When i am trying to laod a partition table i got an error as UNEXPECTED PROCESSING ERROR, REASON=X'00E40318' ON TABLE DSNUGBAC - RESOURCE UNAVAILABLE REASON 00C90099 TYPE 00000220 It tells me that high key on index to be increased. How to fix this Thanks

i have a table with columns i have to alter two columns with default value as 'Y'. Please let me knwo how can i achieve it. i tried using the alter but it is not supporting the syntax. alter table <table name> alter column <column name> set default 'y'; i dont think db2 support this kind of...

I would like to ask a question about how can i see whether a TS was in copy pending status yesterday. Now the TS in RW mode.

Hey, I fixed by incresing the LOBVALA value.

When i am trying to update a blob object am getting error : SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900D1;00000907 always. How to investigate this and possible solution to this.

Thank you all...it got typo i am not a DB2 DBA.

Marc, I am new to DB2 on main frames. Soi asked that question. More over the job completed. I dont know from where i can gather the information. The batch job ran yesterday and is there a possibility of analyzing it today.

Can any one help me on how to analyze the performance of a batch job which deals with cobol and db2. Am a DB2 DBA.