Personal tools
You are here: Home
Navigation
Log in


Forgot your password?
 

Search results

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

46 items matching your criteria. RSS Feed
Convert a table structure for a table [1%] by kanakaraju, 2010-09-19 11:42
I need a few instuructions how to approach the following scenarios.For a given TABLENAME a script should display the following structure on the ...
Re: Any one help? [1%] by kanakaraju, 2010-09-14 13:59
Hello Mr Oliver, Do u have any sample code to do such kind of selection? or do u have any sample SQLs for this case ?(just two independent databases ...
how to compare data in 2 identical table? [1%] by kanakaraju, 2010-09-14 11:41
Hello All, i have 2 identical tables tables in LUW database and host server , and i did a federation setup between LUW database and HOST db   now i ...
Re: Any one help? [1%] by kanakaraju, 2010-09-14 11:38
Hello Mr.Oliver, yes i have federation setup between 2 identical tables.so i need to compare the objects of the 2 tables using syscatalog information. ...
Re: Any one help? [1%] by kanakaraju, 2010-09-14 11:37
Previously Olivier Windels wrote: Hi, Are those federated databases or just two independent databases like for instance: one for homologation ...
Any one help? [1%] by kanakaraju, 2010-09-09 11:10
Hi,   I have two database which reside on two different subsystem respectively.  I would like to generate a list of matching and non matching tables list ...
how to rename Conversion lable/table [1%] by kanakaraju, 2010-08-26 16:46
Hi all, Any body knows the exact mechanism/Functionality of conversion tables (.cnv files) which are under C:\Program Files\IBM\SQLLIB\conv\alt . I have ...
How to add new entries [1%] by kanakaraju, 2010-08-19 12:41
Hi All, Can i know do we have equalent table for SYSIBM.SYSTRING in LUW.? As this table is in Z/OS do we have same equalent table in LUW?? ...
Re: how to resolve this situation? [1%] by kanakaraju, 2010-08-17 10:58
Previously kanakarajuy wrote: Previously wrote: Hello kanakarajuy , You have to turn off all ...
Re: how to resolve this situation? [1%] by kanakaraju, 2010-08-17 10:53
Previously wrote: Hello kanakarajuy , You have to turn off all FKs for these tables. Regards, ...
how to resolve this situation? [1%] by kanakaraju, 2010-08-13 09:41
I am doing loading of tables from z/os to LUW. i used db2move load -io replace option.for this few tables are going to check pending state and hense ...
Need a document link [1%] by kanakaraju, 2010-06-25 10:23
Hi , Can i have  a document link or a document which shows the consideration or steps while migrating a database from mainframes to LUW. ...
Need docs on these concepts [1%] by kanakaraju, 2010-05-14 07:27
DB2move, DB2connect, range partitioning,security,compression all these in DPF (Database partition Feature ENV)..Please help me out Regards ...
Need help how to tune federated objects [1%] by kanakaraju, 2010-04-16 03:41
Hi, Any body helps me how to tune federated database objects ...Like i am facing one issue when i am passing dynamic sql to SQL which should fetch ...
steps to setup federated databases in db2 windows [1%] by kanakaraju, 2010-03-10 06:35
Hi , Can any body guide me the steps to implement the federated databases in db2 on windows environment. Regards kanak
SQL replication document [1%] by kanakaraju, 2010-02-25 10:08
Can any body share the practical document which provides step by step informaton about the SQL replication in db2? Regards kanak
Re: Need help on reduce the % of CPU usage [1%] by kanakaraju, 2010-02-19 03:18
Previously wrote: Please, provide us your top -c screen. sent using gmail Regards kanak
Need help on reduce the % of CPU usage [1%] by kanakaraju, 2010-02-18 10:33
We are facing an issue in one  environment.We are having  total 3 instances .Under each instance different databases are running. Issue is db2inst2 is ...
requesting for date add link [1%] by kanakaraju, 2010-02-10 04:28
Can any body provide the link which describes about dateadd,datediff,related link to me . Regards kanak
can we delete the transaction logs [1%] by kanakaraju, 2010-01-11 12:12
Hi my db has setup circular logging , and i am planning to delete the transaction logs is this a best practice ?? as my SQLOGDIR has occupied ...
how to rectify this error ? [1%] by kanakaraju, 2009-11-27 17:09
body { margin: 0 0 0 0; padding:0 0 0 0 } td,div { font-family:Verdana;font-size:10pt;vertical-align:top } body { margin: 0 0 0 0; padding:0 0 0 0 ...
Re: request for a db2 querry [1%] by kanakaraju, 2009-11-26 07:25
THanks, Can you pls give me the SQL to get the tablespace names and bufferpool names in for a given database Regards kanak
request for a db2 querry [1%] by kanakaraju, 2009-11-25 09:01
Can  any one share a direct db2 SQL to list out the all  table names of a given schema into single file Regards kanak
Getting error while loading [1%] by kanakaraju, 2009-06-07 01:20
Hi,   I am facing one issue in my database . Can any one try to resolve this issue or even suggessions are welcome.     On one ...
Re: Error in db2 size procedure [1%] by kanakaraju, 2009-01-21 07:53
Previously wrote: Hi Kanakarajuy, You have another option to discover the size of database when this routine doesn't work. Execute the ...
Error in db2 size procedure [1%] by kanakaraju, 2009-01-20 08:24
Getting the following error for a db , for rest all dbs under the same instance  it's working fine , any ideas anyone ? ...
How to upgrade a fix pack in UNIX [1%] by kanakaraju, 2009-01-06 11:21
Hi , can any one give me the process how to upgrade a fixpack in UNIX OS.actually my current version is 8.2.2.I need to upgrade to higher version. ...
how to install in AIX [1%] by kanakaraju, 2008-12-27 08:02
HI can any one share how to install DB2 in AIX server . Regards kanakaraju.Y
child table and parent tables [1%] by kanakaraju, 2008-12-22 07:26
Hi can any one tell me how to find out parent and child table of a table in aschema Regards kanak
Any one know the syntax of SQL for this [1%] by kanakaraju, 2008-12-22 07:19
Hi i need to find out child key and parent key for a table in a schema.can any one post any querry for this. Regards kanakaraju.Y
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls