User Profile

Collapse

Profile Sidebar

Collapse
karpalmera
karpalmera
Last Activity: Oct 2 '08, 09:59 AM
Joined: Jun 29 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • karpalmera
    started a topic Row_number() over() not working in SPUFI
    in DB2

    Row_number() over() not working in SPUFI

    Hello! I am using UDB 8 in Z/OS and I am trying to execute this statement in SPUFI
    Code:
    select dept, name, row_number() over()
from staff
    It just doesn't work. Here is the error message:
    Code:
    ---------+---------+---------+---------+---------+---------+---------+---------
  SELECT DEPT, NAME, ROW_NUMBER() OVER() FROM DBPROD.STAFF;
---------+---------+---------+---------+---------+---------+---------+---------
    ...
    See more | Go to post
    Last edited by docdiesel; Oct 4 '08, 09:36 AM. Reason: Added code tags
    • karpalmera
      started a topic Deletion from a large table (with two child tables) takes more than an hour
      in DB2

      Deletion from a large table (with two child tables) takes more than an hour

      Hello!

      We are trying to delete 1,500 records from a parent table with two child tables
      and it is taking hours to execute.

      Here is the set-up.
      - The parent table has 800,000 records. Child table A has 2.3 M records. Child table B has 200,000 records.
      - The parent table has 5 indexes. Child table A has 6 indexes and Child table B has one index.
      - Both child tables has contraints with 'on...
      See more | Go to post
      • karpalmera
        started a topic Oracle transparent gateway in z/os
        in Oracle

        Oracle transparent gateway in z/os

        We are currently migrating from OS/390 to Z/OS and our DB2 from DB2 4 to DB2 UDB8. However, our Oracle Database and Oracle gateway will remain the same..Oracle database is 7.2.3 and Oracle gateway is 7.3

        We have a hard time starting our Oracle gateway in Z/OS. Has anyone experienced this kind of migration? Is it possible for Oracle 7 to run in Z/OS? If so, can you please explain what parameters we need to change in order for our old...
        See more | Go to post
        • karpalmera
          replied to ORA-02068: severe error from ORAMVS
          in Oracle
          ORAMVS is our Oracle in MVS(Multi Virtual Storage).
          Oracle in Mainframe. Our mainframe is OS/390.

          Our mainframe is using DB2.

          Background: We need this ORACLE-DB2 connection because we make view tables in oracle for DB2 base tables.

          thanks!...
          See more | Go to post

            Leave a comment:

          • karpalmera
            replied to ora-01033 oracle initialization or shutdown in process
            in Oracle
            hi, FHKHAN78!

            what if I am using this version
            Oracle7 Server Release 7.2.3.0.0 - Production Release
            With the distributed option
            PL/SQL Release 2.2.3.0.0 - Production?

            what can i try?

            thanks!
            See more | Go to post

              Leave a comment:

            • karpalmera
              started a topic ORA-02068: severe error from ORAMVS
              in Oracle

              ORA-02068: severe error from ORAMVS

              We have checked the status of listener and it's okay.
              ORAORD7, TNSG473 & G4G407 are okay.
              Still, we are encountering this problem when trying to connect to DB2.
              =============== =============== =============== ======
              Oracle7 Server Release 7.2.3.0.0 - Production Release
              With the distributed option
              PL/SQL Release 2.2.3.0.0 - Production

              SQL> desc tablev@oramvs
              ERROR:
              ORA-02068:...
              See more | Go to post
              • karpalmera
                started a topic -922 in COBOL CICS DB2 program
                in DB2

                -922 in COBOL CICS DB2 program

                Please help me...I encountered this error in COBOL CICS DB2 Program
                TRAN ID, program name & user id have been given grants. TRAN ID is already defined in RCT.
                Is this a program error or we failed to define something in TSO?

                =============== =============== =============== =========
                TRANSACTION: RSD2 PROGRAM: RSM01COO TASK: 0000396 APPLID: TST3CICS DISPLAY: 00
                STATUS: COMMAND EXECUTION COMPLETE
                ...
                See more | Go to post
                • karpalmera
                  replied to difference in number of records for select count(*) and select *
                  in DB2
                  We have REORG the table. This seems to solve the problem. The number of records for select * and select count(*) are now the same.

                  But I still want to know the reason behind it.

                  I'll try the select count per column if the problem arises again.

                  I'll give an update regarding this..Super thanks!

                  =============== =============== =============== ====...
                  See more | Go to post

                    Leave a comment:

                  • karpalmera
                    replied to How to Terminate a Load Utility
                    in DB2
                    hello, try displaying the utility id first using -DIS UTIL(*)
                    then, when you see the utility id, terminate it using -TERM UTIL(loadpc) where loadpc is the utility id.

                    hope this works for you...
                    karpalmera...
                    See more | Go to post

                      Leave a comment:

                    • karpalmera
                      started a topic difference in number of records for select count(*) and select *
                      in DB2

                      difference in number of records for select count(*) and select *

                      We are trying to do select count(*) and select * from the same table.

                      We have executed the following:
                      when we execute
                      Code:
                      SELECT COUNT(*)
FROM TABLE1;
the result is 0
                      but when we execute
                      Code:
                      SELECT *
FROM TABLE1;
                      the result is..
                      Code:
                      COLUMN1   COLUMN2
1                 A
2                 B
                      two records selected.

                      what could possibly cause...
                      See more | Go to post
                      Last edited by eWish; Dec 30 '07, 03:50 PM. Reason: Added Code Tags
                      • karpalmera
                        replied to Long running of DB2 Queries
                        in DB2
                        Yes! it worked for both development and production environments..

                        Here is what we did....
                        in our development environment:
                        1. we dropped all indexes and tables
                        2. created the table and defined the primary index with clustering
                        3. restored all data
                        4. created other indexes
                        5. RUNSTATS
                        6. rebind programs
                        7. run programs


                        in our production environment:
                        1. we dropped all indexes
                        2. defined the primary index with clustering
                        3. REORG
                        4. created
                        ...
                        See more | Go to post

                          Leave a comment:

                        • karpalmera
                          replied to Long running of DB2 Queries
                          in DB2
                          hello...i just found out that both environments were clustered with INDEX1.
                          :)
                          See more | Go to post

                            Leave a comment:

                          • karpalmera
                            replied to Long running of DB2 Queries
                            in DB2
                            thank you so much, snib and ben...!!!!
                            i'l update you, guys...thank you!!!
                            See more | Go to post

                              Leave a comment:

                            • karpalmera
                              started a topic Long running of DB2 Queries
                              in DB2

                              Long running of DB2 Queries

                              Hello! If there’s anyone who can help with this problem…

                              We created two working environments, creating the same table (TABLEX), same indexes (INDEX1, INDEX2 & INDEX3) and executing the same SQL Statements (SQL1, SQL2 & SQL3) thru spufi. Here is exactly what we did.

                              For both environments, these SQL statements were created. The ‘where clause’ of the first SQL statement is patterned after INDEX1. The ‘where...
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...