Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: krishrad
  • Content: Threads
  • Order by date
  1. krishrad

    load into a single partiton on a multi partitioned table

    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.
  2. krishrad

    need info

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

    Reg: invloking admin rights from a user id

    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.
  4. krishrad

    Db2 Error- REASON 00C90099

    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
  5. krishrad

    set column to default in db2

    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...
  6. krishrad

    How to find past history of TS status

    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.
  7. krishrad

    update a table with blob data type-: SQLCODE: -904, SQLSTATE: 57011, S

    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.
  8. krishrad

    performance of a batch job ran and no current threads available

    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.
  9. krishrad

    Performance of a batch job (cobol db2)

    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.

Part and Inventory Search

Back
Top