User Profile

Collapse

Profile Sidebar

Collapse
fahimghauri
fahimghauri
Last Activity: Nov 19 '08, 05:32 AM
Joined: Mar 12 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • fahimghauri
    replied to Sqlcode=-443, Sqlstate=38553 Sysibm:cli:-727
    in DB2
    Granting SELECT on SYSIBM tables solved the problem.

    But. . .
    It raised some more questions in my mind.

    1. Why Non DBADM user requires access to SYSIBM tables (metadata)?
    2. Why JDBC connection requires these privileges?
    3. I have another server, On which same user exists, I have not explicitly granted select on sysibm tables to user on that server,
    But even then the user can select...
    See more | Go to post

      Leave a comment:

    • fahimghauri
      replied to Generate DDL of Schema
      in Oracle
      thanks Debasisdas,

      But this is not desired. I need only SQL commands (DDL) as a text file,if its possible.

      As I said, It is possible to create DDL of a single table, if it is possible for a single table then it must be possible to generate for all tables, I guess through some API or database procedures. But I am unable to find until now. . .

      Regards,
      Fahim...
      See more | Go to post

        Leave a comment:

      • fahimghauri
        started a topic Sqlcode=-443, Sqlstate=38553 Sysibm:cli:-727
        in DB2

        Sqlcode=-443, Sqlstate=38553 Sysibm:cli:-727

        Hi,

        DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM .SQLCOLUMNS;COL UMNS;SYSIBM:CLI :-727, DRIVER=3.50.152


        My developers receive this error trying to run queries on a DB2 V8.2 database on linux, through JDBC drivers, exactly like an IBM page describe this:

        http://www-1.ibm.com/support/docview.wss?uid =swg1LI70279

        But the strange thing is, that if the users has DBA authority...
        See more | Go to post
        • fahimghauri
          started a topic Generate DDL of Schema
          in Oracle

          Generate DDL of Schema

          Hi,

          How can DDL of a schema be generated in oracle, as in DB2 db2look command provide the facility?
          I can generate DDL from enterprise manager, but that create generate DDL of a single table and also does not generate DDL of Foreign keys.

          Regards,
          Fahim
          See more | Go to post
          • fahimghauri
            started a topic Multiple db2diag.log files
            in DB2

            Multiple db2diag.log files

            Hi,

            Can I have multiple db2diag.log files ? (a separate file for each database).

            Regards,
            Fahim Ghauri
            See more | Go to post
            • fahimghauri
              started a topic Visual Explain after applying Fixpack 15 on v8.1
              in DB2

              Visual Explain after applying Fixpack 15 on v8.1

              Hi,

              I upgraded my DB2 8.1 upto fixpack 15, before this it was on level 7.

              After upgrade when I explain the Sql statement I get the following error:

              ------------------------------ ERROR ---------------------------------------
              DBA3065E Snapshot cannot be processed due to a CLI error.

              Explanation:

              A CLI error has occurred during snapshot processing. An access ...
              See more | Go to post
              • fahimghauri
                replied to Large Table Index Rebuild Problem
                in DB2
                Thanks Sanjay,

                I am really grateful to you, you replied with details.

                I'll try these tips in evening, Will tell you the result.

                Thanks again

                Fahim
                See more | Go to post

                  Leave a comment:

                • fahimghauri
                  started a topic Large Table Index Rebuild Problem
                  in DB2

                  Large Table Index Rebuild Problem

                  Hi all,

                  I DB2 v8.1 FixPack 15 on Linux. I have a table which has over 6 Million rows When I query that table it takes too much time even if I query for first 10 rows only. It also gives error "Log File has reached its saturation point", and ADM5543E Index rebuild of indexes on table.

                  Some times it crashes the database manager.

                  Please help how can I manage that table efficiently???
                  and...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...