DBA to DBA

workload manager???

db2dba — 2013-03-04T06:28:47Z

Re: SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() error

db2dba — 2011-05-27T04:25:04Z

thanks but then whats use of SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()? could you tell me few reasons why objects are getting invalid? Previously wrote: 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.

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() error

db2dba — 2011-05-25T16:23:02Z

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.

Re: any feature like oracle flashback database in db2

db2dba — 2011-05-25T16:18:41Z

thanks perellis

any feature like oracle flashback database in db2

db2dba — 2011-04-27T04:19:12Z

Hi All, Oracle has one feature flashback database. Similer DB2 has any feature?? Thanks....

how to make database read only

db2dba — 2010-12-20T06:35:41Z

Hi, How to make database read only?

index reverse scan

db2dba — 2010-12-09T09:51:33Z

Hi ,
Can anyone tell me how index reverse scan actually work with example?

Regards
Pawan Kumar

Re: db2 certification 730 dump?

db2dba — 2010-10-27T07:35:34Z

I secured 90% in db2 730 certification.

db2 certification 730 dump?

db2dba — 2010-10-18T13:59:25Z

Hi All, I am planning to write for db2 730 certification. If anyone has dump for this certification please share with me. pawan.porwal@hotmail.com Thanks Pawan

migration steps v8 to v9

db2dba — 2010-07-29T05:30:06Z

Hi All, Please provide migration steps from v8 to v9 db2 or any docs for the same. Thanks

what is db2 architecture?

db2dba — 2010-07-07T04:28:43Z

Hi All, What is physical and logical architecture of db2? Regards

files system is about to reach to max

db2dba — 2010-05-19T09:56:53Z

Hi, OS : AIX 32 Bit DB2 V8.2 Single Partition All SMS Tablespace As AIX 32 bit support maximum 1 TB for one file system and now file system is about to reach 1TB? so what should I do?? we can not add container in sms tablespace... Please suggest approch? Regards Pawan Kumar

How does clustered Index work exactly in DB2?

db2dba — 2010-03-15T13:14:13Z

How does clustered Index work exactly in DB2? Please explain with an example.. Regards Pawan Kumar

few questions related to db2

db2dba — 2010-03-12T16:54:41Z

&lt;!-- @page { margin: 0.79in } P { margin-bottom: 0.08in } --&gt; 1.If application team is contacting you telling the application is running very slow , what all things you will check out ? 2.If you are given with a query,how you tune it? Regards Pawan

Re: dba activities

db2dba — 2009-09-29T06:28:34Z

http://www.ibm.com/developerworks/data/library/techarticle/dm-0404snow/index.html http://www.ibm.com/developerworks/data/library/techarticle/dm-0509poon/ http://www.ibm.com/developerworks/data/library/techarticle/dm-0404mcarthur/ http://www.selectorweb.com/db2.html http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.qb.server.doc/doc/r0024443.html http://www.ibm.com/developerworks/data/library/techarticle/dm-0406qi/