Search results

Did you not find what you were looking for? Try the Advanced Search for more precise search options.

89 items matching your criteria.

Re: SQL1427N An instance attachment does not exist. [1%] by perallis, 2013-03-12 11:15: First: db2 attach to instance_name Then: db2 get dbm cfg show detail
Re: inctive logs in active log path. [1%] by perallis, 2013-01-07 09:56: How many logs are defined on logprimary on db2 cfg? What is your archive log path ? Thank you!
Re: help required for db2 dba [1%] by perallis, 2012-09-20 10:53: 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...
Re: Hi help me [1%] by perallis, 2012-01-04 18:21: Hello Siddhu, Soon we will provide advanced courses to working with advanced database subject, such as: - High Avaiability - Scalability - Big ...
Re: Request [1%] by perallis, 2012-01-04 18:15: 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 ...
Re: SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() error [1%] by perallis, 2011-05-26 16:29: You have to correct this procedure - drop and recreate it with the correct objects. Previously Pawan wrote: Hi, I tried to use ...
Re: any feature like oracle flashback database in db2 [1%] by perallis, 2011-05-20 16:40: Hi Pawan, You can use the command below: db2 rollforward database <dbname> user <username> using db2admin to end of logs and complete ...
Re: how to resolve this situation? [1%] by perallis, 2010-08-18 22:13: db2 alter table <tbname> drop foreign key <foreign_name> or db2 alter table <tbname> alter foreign key <foreign_name> not ...
Re: how to resolve this situation? [1%] by perallis, 2010-08-13 09:39: Hello kanakarajuy , You have to turn off all FKs for these tables. Regards, Perallis
Re: what are the DB memory areas in db2 udb? [1%] by perallis, 2010-03-24 17:19: http://www.ibm.com/developerworks/data/library/techarticle/dm-0406qi/ Regards, Perallis
Re: How does clustered Index work exactly in DB2? [1%] by perallis, 2010-03-15 15:24: Clustered and non-clustered indexes Index architectures are classified as clustered or non-clustered. Clustered indexes are indexes whose order of the ...
Re: few questions related to db2 [1%] by perallis, 2010-03-12 13:55: 1.If application team is contacting you telling the application is running very slow , what all things you will check out ? - Check table reorganization ...
Re: steps to setup federated databases in db2 windows [1%] by perallis, 2010-03-10 10:28: http://www.dbatodba.com/db2/how-to-do/how-to-use-db2-federation
Re: Need help on reduce the % of CPU usage [1%] by perallis, 2010-02-21 13:04: 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 ...
Re: Need help on reduce the % of CPU usage [1%] by perallis, 2010-02-18 15:17: Please, provide us your top -c screen.
Re: can we delete the transaction logs [1%] by perallis, 2010-01-14 08:52: You can't delete transactions log. When you are using circular logging the DB2 reuses the number of logs defined on LOGPRIMARY and LOGSECOND.
Re: question about pydb2 [1%] by perallis, 2009-12-23 08:20: Try to use fetchone() and tell us the result. Regards, Vinicius Perallis DBA DB2
Re: database [1%] by perallis, 2009-12-22 14:22: db2 connect The command above shows which is database you are working. And the command: db2 list active databases, shows all databases active in ...
Re: request for a db2 querry [1%] by perallis, 2009-11-30 15:46: TABLESPACES db2 list tablespaces show detail or db2 "select TBSPACE from syscat.tablespaces" or db2pd -d <dbname> -tablespaces or db2look -d ...
Re: how to rectify this error ? [1%] by perallis, 2009-11-30 15:38: db2 " ? sql289n" SQL0289N Unable to allocate new pages in table space "<tablespace-name>". Explanation: One of the following ...
Re: request for a db2 querry [1%] by perallis, 2009-11-25 13:10: select rtrim(tabschema),rtrim(tabname) from syscat.tables where tabschema=<SCHEMA_NAME>
Re: CALL SEQUENCES WITHOUT SCHEMA PREFIX [1%] by perallis, 2009-07-17 15:01: You have to set the specific schema before: db2 set schema <schema_name>    
Re: How to check how many indexes are created on a specific table. [1%] by perallis, 2009-07-07 17:08:   db2 describe indexes for <schema_name>.<table_name> show detail   or   you can check the how many index are ...
Re: Select null as xyz from sysibm.sysdummy1--not work???? [1%] by perallis, 2009-07-03 17:51: On DB2 you have to use nullif(0,0) to select numeric data oy nullif('0','0'), see the example below: db2 "select nullif(0,0) from sysibm.sysdummy1"
Re: Getting error while loading [1%] by perallis, 2009-06-08 10:42: Access the link below to see the solution to the error above: insert-and-delete-errors-sql0668n
Re: db2explain and runstat [1%] by perallis, 2009-05-13 13:31: Example, for table staff and for query "select * from staff where id=10" Before you run the db2expln, you have to enable the explain tables, see the ...
Re: Select [1%] by perallis, 2009-05-11 09:07: Hi Nair,   db2a is my database, your database is carddemo, create server sevdb2a type DB2/UDB version '9.5' wrapper drda authorizaton rknair ...
Re: Select [1%] by perallis, 2009-05-08 09:01: Nair,   Yes, it is possible to federate databases on DB2 9.5 Express, you are getting syntax error.   Execute the command below on ...
Re: Select [1%] by perallis, 2009-05-07 15:36:   If your Username:rknair and Password:rknair123, try the command below, and type it out of CLP, so puu the word "db2" to execute it, as the line ...
Re: Select [1%] by perallis, 2009-05-07 12:59: Yes, It is possible to federate database on DB2 9.5 Express.   Please, put here your command and the output error.   Regards, Perallis ...

Next 30 items » [1] 2 3

DBA to DBA

Personal tools

Search results

Would you like your company to implement gamification into your security awareness program?