http://www.dbatodba.com These are the search results for the query, showing results 1 to 15. http://www.dbatodba.com/Forums/db2/26741739/838276641 I need a few instuructions how to approach the following scenarios.For a given TABLENAME a script should display the following structure on the screen.The structure should be as below.for a given perticular table. SELECT *FROM TAB1 a JOIN TAB1 b ON a.PK1=b.PK1 where a.col1 <> b.col1 or a.col2 <> b.col2 or a.col3 <> b.col3 or . . . . a.coln <> b.coln ; The above structure is useful to check the updated records count to compare with old version table.Please help to suggest an approach to do this or any commands will do for this ? No publisher kanakaraju 2010-09-19T14:42:57Z Comment http://www.dbatodba.com/Forums/db2/360853029/584835414 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 like for instancejust two independent databases like for instance) if so please provide those i am just checking the different options for starting point. Regards kanaka No publisher kanakaraju 2010-09-14T16:59:10Z Comment http://www.dbatodba.com/Forums/db2/359353943/725177458 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 have compared the data between these 2 tables and updated columns using below commands.   select *from s1.TLPRZUL_BEDG where BEDG_NR NOT IN (select BEDG_NR from s1.TLPRZUL_BEDG_tst) order by BEDG_NR; select *from s1.TLPRZUL_BEDG_tst where BEDG_NR NOT IN (select BEDG_NR from s1.TLPRZUL_BEDG) order by BEDG_NR; select *from s1.TLPRZUL_BEDG A JOIN s1.TLPRZUL_BEDG B ON A.BEDG_NR=B.BEDG_NR where A.MANDANT_NR <> B.MANDANT_NR or A.OBJEKT_VERSION <> B.OBJEKT_VERSION or A.BEDG_KURZBEZ <> B.BEDG_KURZBEZ or A.BEDG_NAME <> B.BEDG_NAME or A.BEDG_BESCHRBG <> B.BEDG_BESCHRBG or A.F_ONLINE_NAME <> B.F_ONLINE_NAME or A.REIHENFOLGE <> B.REIHENFOLGE or A.BEDG_ART_NR <> B.BEDG_ART_NR or A.BEDG_DLCBEZ <> B.BEDG_DLCBEZ or A.SELEKTIONSNR <> B.SELEKTIONSNR or A.KZ_INHALTSVERZ <> B.KZ_INHALTSVERZ;   is there any way to do these 3 steps using syscatlog tables for a given 2 tables?? or any short script to do this comparision? Now i am looking for compare this kind of scenario using syscatlog tables dynamically with out hard coding the column names for a given 2 identical table. Regards No publisher kanakaraju 2010-09-14T14:41:59Z Comment http://www.dbatodba.com/Forums/db2/360853029/125788993 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. Any help is appriciable. Thanks &Regards kanaka No publisher kanakaraju 2010-09-14T14:38:25Z Comment http://www.dbatodba.com/Forums/db2/360853029/474030316 Previously Olivier Windels wrote: Hi, Are those federated databases or just two independent databases like for instance: one for homologation and the other for production environment? Olivier 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. Any help is appriciable. Thanks &Regards kanaka No publisher kanakaraju 2010-09-14T14:37:23Z Comment http://www.dbatodba.com/Forums/db2/360853029/797958249 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 And one more is I need to find out columns list,indexes list ,views list ,keys list  for given 2 identical tables,  Do we have any sql to generate this report from SYSIBM tables. Thank you in advance. No publisher kanakaraju 2010-09-09T14:10:35Z Comment http://www.dbatodba.com/Forums/db2/667198592/710660594 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 2 codepage sets 1.Source(850) 2.Target(923). I have some lables are missing in during the data export and import from Z/os to LUW.I have gone through the IBM manuals there its mentioned about hte .cnv ,.ucs files. so i want to know the exact mechanism how to renames the .csv and .ucs files based given codepages above. Appriciate your help. Regards kanaka No publisher kanakaraju 2010-08-26T19:46:44Z Comment http://www.dbatodba.com/Forums/db2/201136583/530489990 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?? .How to add new entries to this table ?? Regards kanaka No publisher kanakaraju 2010-08-19T15:41:23Z Comment http://www.dbatodba.com/Forums/db2/25194711/595656127 Previously kanakarajuy wrote: Previously wrote: Hello kanakarajuy , You have to turn off all FKs for these tables. Is this right way of doing the import? can we get accurate and consistence data to be loaded into database with this approach?? Regards, Perallis Hello Peralls, Thanks for your help.You mean i need to turn OFF the FKs during import and again turn ON once import is done is it ? could you pelase help me how to turn of the all FKS ...i mean i need a syntax to trun OFF. Appriciate your help. Thanks kanaka No publisher kanakaraju 2010-08-17T13:58:38Z Comment http://www.dbatodba.com/Forums/db2/25194711/870309773 Previously wrote: Hello kanakarajuy , You have to turn off all FKs for these tables. Regards, Perallis Hello Peralls, Thanks for your help.You mean i need to turn OFF the FKs during import and again turn ON once import is done is it ? could you pelase help me how to turn of the all FKS ...i mean i need a syntax to trun OFF. Appriciate your help. Thanks kanaka No publisher kanakaraju 2010-08-17T13:53:06Z Comment http://www.dbatodba.com/Forums/db2/25194711/442273527 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 tablespace is also going to check pending state. so i thought of using db2move import -io replace option but for this its giving the below error. I am loading a parent table getting below error any idea how to rectify this situation?? SQL3153N The T record in the PC/IXF file has name "tab2.ixf", qualifier "", and source " ". SQL3201N The specified table cannot be replaced because another table is dependent on it. SQL3110N The utility has completed processing. "0" rows were read from the input file. sl000247:/db2mig/data/5_provi $ db2 ? SQL3201N SQL3201N The specified table cannot be replaced because another table No publisher kanakaraju 2010-08-13T12:41:16Z Comment http://www.dbatodba.com/Forums/db2/786583451/885744633 Hi , Can i have  a document link or a document which shows the consideration or steps while migrating a database from mainframes to LUW. Currently i am working on migrating a database from MAINFRAMES to LUW. i need some body help to follow the what are the consideration required to be follow while migrating a database from Z/OS to LUW. Do we have any predefined steps to follow while migration ? Regards kanaka No publisher kanakaraju 2010-06-25T13:23:43Z Comment http://www.dbatodba.com/Forums/db2/856205095/650386846 DB2move, DB2connect, range partitioning,security,compression all these in DPF (Database partition Feature ENV)..Please help me out Regards kanaka No publisher kanakaraju 2010-05-14T10:27:58Z Comment http://www.dbatodba.com/Forums/db2/727769518/987919723 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 values from federated datasource.its really taking huge time to respond. if suppose if i pass SQL with static values the results are coming very fast.You can find the examples below. 1.THe below is the querry which is taking long time to fetch only 2660 records.dynamic values should fetch from MQT table. SELECT a.ACCOUNT_ID,        a.Week_Ending_Date,        a.Emp_Last_Name,        a.Emp_Ser_Num,        a.Country_Code,        a.Division_Code,        a.Emp_Dept_Number,        a.Emp_Level_Code,        a.Total_Hrs_Expended,        b.COUNTRY_DESC   FROM USER1.LABOUR_DETAILS_UV a,        USER1.COUNTRY_REF_DETAILS b     WHERE a.country_code = b.country_cd     AND a.account_id IN (select * from DB2ADMIN.CLAIM_MQT_TAB); 2.if we pass same with static values its giving results very fast...some thing like below . SELECT a.ACCOUNT_ID,        a.Week_Ending_Date,        a.Emp_Last_Name,        a.Emp_Ser_Num,        a.Country_Code,        a.Division_Code,        a.Emp_Dept_Number,        a.Emp_Level_Code,        a.Total_Hrs_Expended,        b.COUNTRY_DESC   FROM USER1.LABOUR_DETAILS_UV a,        USER1.COUNTRY_REF_DETAILS b     WHERE a.country_code = b.country_cd     AND a.account_id IN ('X','Y','Z'); your help is appricaite. Regards kanak No publisher kanakaraju 2010-04-16T06:41:23Z Comment http://www.dbatodba.com/Forums/db2/91316468/788892713 Hi , Can any body guide me the steps to implement the federated databases in db2 on windows environment. Regards kanak No publisher kanakaraju 2010-03-10T09:35:44Z Comment