User Profile

Collapse

Profile Sidebar

Collapse
srilata83
srilata83
Last Activity: Oct 27 '10, 10:36 AM
Joined: Aug 4 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • srilata83
    started a topic 'hash index' in DB2 V10.
    in DB2

    'hash index' in DB2 V10.

    Hi All,
    Could anyone please explain me about 'hash index' in DB2 V10 with the examples.Any amerials or materilas can be shared with me will be highly appreciated.

    Also, someone has expalined abot this like"V10 introduces ‘Hash’ indexes which will incur only a single I/O to get to the DB2 data row (i.e. very fast access). The requirements are that the ‘Hash’ index be unique and that SELECT SQL using the index...
    See more | Go to post
    • srilata83
      started a topic Check-pending status in DB2
      in DB2

      Check-pending status in DB2

      Hi,
      we are running some DB2 load utilty job to empty the DB2 (multiple) tables by loading with a dummy file.we are giving in the control card as follows
      ===>
      LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE
      creator.tablena me1 NOCOPYPEND
      LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE
      creator.tablena me2 NOCOPYPEND
      ...
      See more | Go to post
      • srilata83
        started a topic Code level Mismatch
        in DB2

        Code level Mismatch

        Hi,
        My DB2 system running on V9 compatibility mode, which is upgraded recenly . We are running a job, for which I am getting following error.
        IDBDB2CA- SSID XXXX ERROR, CODE LEVEL MISMATCH
        I suspected as my plan is running in older version, so i tried to bind the plan, but its also faling with an errror
        BPA0016E: DB2 UTILITY APPLICATION - INCOMPLETE.
        BPA0023E: TSO SERVICE FACILITY FAILED.
        PT282E: UNABLE...
        See more | Go to post
        • srilata83
          started a topic How to get the stored procedure information?
          in DB2

          How to get the stored procedure information?

          Hi All,

          I dont know much about stored procedure.I am being asked to increase the ASUTIME LIMIT parameter .I know that to alter the parameter. i have to get the stored procedure and from there only i can alter the parameter.But the requesting team doesnt know where to get stored procedure name.Do anybody help?Or is there any other way to increase this Limit?The job is a db2 unload utility.Hw can i alter this limit and how to get the...
          See more | Go to post
          • srilata83
            started a topic hw to get the stored procedure information?
            in DB2

            hw to get the stored procedure information?

            Hi All,

            I am being asked to increase the ASUTIME LIMIT
            parameter .I know to alter the parameter. i have to get the stored procedure and from there only i can alter the parameter.But the requesting team doesnt know where to get stored procedure name.Do anybody help?Or is there any other way to increasse this Limit?

            Thanks in advance.
            See more | Go to post
            • srilata83
              replied to -802 error for count(*) query for a DB2 table
              in DB2
              Thank you, Vijay.

              I came to know a new thing from u....

              Thanks a lot.... :)
              See more | Go to post

                Leave a comment:

              • srilata83
                started a topic -802 error for count(*) query for a DB2 table
                in DB2

                -802 error for count(*) query for a DB2 table

                Hi,
                I am trying to query a big table which contains huge data,I just tried to check the no of records of table, i have run the query for COUNT(*) in QMF, But i am not getting the result , i am getting an error -802 ,saying commit frequency must be greater than zero.
                Is there any way of getting the count?
                I tried in platinum tool also, but its N/A over there in 'No. of rows' field.

                Please help me in this reg...
                See more | Go to post
                • srilata83
                  started a topic Alter an index in DB2
                  in DB2

                  Alter an index in DB2

                  Hi,

                  I have to alter an index by adding two columns into it.

                  My table contains data and according to the requiremnet the data must be preserved.
                  So i am dropping the index and creating the index with two new columns.
                  Is that enough?But do i need to do anything with data????

                  Please suggest me.

                  Thanks in advance.
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...