http://www.dbatodba.com These are the search results for the query, showing results 1 to 15. http://www.dbatodba.com/Forums/db2/577874120/279398164 First: db2 attach to instance_name Then: db2 get dbm cfg show detail No publisher perallis 2013-03-12T13:15:33Z Comment http://www.dbatodba.com/Forums/db2/577874119/939068046 How many logs are defined on logprimary on db2 cfg? What is your archive log path ? Thank you! No publisher perallis 2013-01-07T11:56:12Z Comment http://www.dbatodba.com/Forums/db2/540739412/197078841 Hello Bannu, Do you known this free DB2 book? http://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C Regards, Vinícius Perallis No publisher perallis 2012-09-20T13:53:15Z Comment http://www.dbatodba.com/Forums/db2/647488338/957285151 Hello Siddhu, Soon we will provide advanced courses to working with advanced database subject, such as: - High Avaiability - Scalability - Big Tables - VLDB(Very Large Database) Regards, Vinicius No publisher perallis 2012-01-04T21:21:59Z Comment http://www.dbatodba.com/Forums/db2/647488339/946959528 Hello Siddhu, Soon, we will provide DB2 trainning in English. I think that our first course will be "How to became a DB2 Database Administrator?" When I have more news, I will let you know. Regards, Vinicius No publisher perallis 2012-01-04T21:15:55Z Comment http://www.dbatodba.com/Forums/db2/724805843/326730501 You have to correct this procedure  - drop and recreate it with the correct objects. Previously Pawan wrote: Hi,     I tried to use SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() procedure to revalidate the invalid objects. DB2 9.7 FP2,Window 32 BIT SP1 is invalid procedure and SP2 is valid. $ db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'A', 'SP1')" SQL20508N  An error occurred during the revalidation of object "A .SP1". Operation "REVALIDATION" failed with SQLCODE "-551", SQLSTATE "42501", and message tokens "PKUMAR|EXECUTE|DTOP".  SQLSTATE=5UA03 Its throwing error related to permission but there exist all permissions even Its running for valid objects. $ db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'A', 'SP2) "   Return Status = 0 I also did db2rbind for all but same error. SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() link=> http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0053626.html Could anyone throw some light on this. No publisher perallis 2011-05-26T19:29:10Z Comment http://www.dbatodba.com/Forums/db2/809220520/258074180 Hi Pawan, You can use the command below: db2 rollforward database <dbname> user <username> using db2admin to end of logs and complete recover dropped table <tabname> to <any location> No publisher perallis 2011-05-20T19:40:04Z Comment http://www.dbatodba.com/Forums/db2/25194711/883555802 db2 alter table <tbname> drop foreign key <foreign_name> or db2 alter table <tbname> alter foreign key <foreign_name> not enforced No publisher perallis 2010-08-19T01:13:18Z Comment http://www.dbatodba.com/Forums/db2/25194711/761474064 Hello kanakarajuy , You have to turn off all FKs for these tables. Regards, Perallis No publisher perallis 2010-08-13T12:39:52Z Comment http://www.dbatodba.com/Forums/db2/344013164/254269053 http://www.ibm.com/developerworks/data/library/techarticle/dm-0406qi/ Regards, Perallis No publisher perallis 2010-03-24T20:19:25Z Comment http://www.dbatodba.com/Forums/db2/94705190/493753256 Clustered and non-clustered indexes Index architectures are classified as clustered or non-clustered. Clustered indexes are indexes whose order of the rows in the data pages correspond to the order of the rows in the index. This is why only one clustered index can exist in a given table, whereas, many non-clustered indexes can exist in the table. In some relational database management systems, the leaf node of the clustered index corresponds to the actual data, not a pointer to data that resides elsewhere. Both clustered and non-clustered indexes contain only keys and record IDs in the index structure. The record IDs always point to rows in the data pages. The only difference between clustered and non-clustered indexes is that the database manager attempts to keep the data in the data pages in the same order as the corresponding keys appear in the index pages. Thus the database manager will attempt to insert rows with similar keys onto the same pages. If the table is reorganized, it will be inserted into the data pages in the order of the index keys. Reorganizing a table with respect to a chosen index re-clusters the data. A clustered index is most useful for columns that have range predicates because it allows better sequential access of data in the table. This results in fewer page fetches, since like values are on the same data page. In general, only one of the indexes in a table can have a high degree of clustering. Improving performance with clustering indexes Clustering indexes can improve the performance of most query operations because they provide a more linear access path to data, which has been stored in pages. In addition, because rows with similar index key values are stored together, prefetching is usually more efficient when clustering indexes are used. However, clustering indexes cannot be specified as part of the table definition used with the CREATE TABLE statement. Instead, clustering indexes are only created by executing the CREATE INDEX statement with the CLUSTER option specified. Then the ALTER TABLE statement should be used to add a primary key that corresponds to the clustering index created to the table. This clustering index will then be used as the table's primary key index. Note: Setting PCTFREE in the table to an appropriate value using the ALTER TABLE statement can help the table remain clustered by leaving adequate free space to insert rows in the pages with similar values. For more information, see the ALTER TABLE statement and Reducing the need to reorganize tables and indexes . Generally, clustering is more effectively maintained if the clustering index is unique. No publisher perallis 2010-03-15T18:24:02Z Comment http://www.dbatodba.com/Forums/db2/94657955/653191697 1.If application team is contacting you telling the application is running very slow , what all things you will check out ? - Check table reorganization -  When to REORG a table on DB2 - Check if there are good indexes -  http://www.dbatodba.com/Forums/db2/157608501/#449402641 - Bufferpool hit ratio -  Monitoring performance with SQL -Buffer pools - Memory parameters 2.If you are given with a query,how you tune it? - Create good indexes - How to check queries that have bad performance - Check possible improvements to your query(Ex.: Eliminate subselects ) - Check if the applications are using prepared statements   Regards Perallis No publisher perallis 2010-03-12T16:55:27Z Comment http://www.dbatodba.com/Forums/db2/91316468/179273495 http://www.dbatodba.com/db2/how-to-do/how-to-use-db2-federation No publisher perallis 2010-03-10T13:28:26Z Comment http://www.dbatodba.com/Forums/db2/441203411/919326981 Please, use the db2top -d <dbaname> coomand to find out which are the applications using a huge percentage of CPU. Verify if you need to create indexes to these statements  Regards, Vinicius Perallis No publisher perallis 2010-02-21T16:04:56Z Comment http://www.dbatodba.com/Forums/db2/441203411/710368338 Please, provide us your top -c screen. No publisher perallis 2010-02-18T18:17:04Z Comment