DB2 | Forum profile

11/06/09 "Metro" NY, page 29 HARD --> 1 sec <-- Code: Source (line, sudoku_str) as ( select 1, '020090800' from sysibm.sysdummy1 union all select 2, '600270003' from sysibm.sysdummy1 union all select 3, '000006210' from sysibm.sysdummy1 union all select 4, '000700008' from sysibm.sysdummy1 union all select 5, '702804109' from sysibm.sysdummy1 union all select 6,...

Quote: Originally Posted by prashantopel Thanks How to create dummy database for practice in DB2 9.7? From DB2 Command Window, enter: db2 create db db2dummy I'd have suggested to create a db called db2dummy1 if db2 allowed the db name to be more than 8 char.

Quote: Originally Posted by Satish K Can you please let me know how to use the functions :- ASCII_STR and EBCDIC_STR in this case? Thx, Satish http://bit.ly/4o3Ykb

Well, it returns a string with 3 characters where the first 2 are blanks. So you have to replace those blacks with 0's.

INSERTing 25 million rows is just asking for trouble. I think it is obvious that the problem is in having to update the index for each inserted record. If you cannot eliminate that by using LOAD or dropping and re-creating the index, I'd say your only other option is to try and speed that up. Minimize page splits by setting both PCTFREE values to something like 90 (the maximum is 99). May be put the PK index into a separate tablespace...

Use SYSIBM tables in good health. SYSCAT views are for those who moved to DB2 from "Query Manager", OS/2, Windows, etc. and have not the capacity to remember SYSIBM names. When you grow up and migrate to DB2 on z/OS, you will not find any SYSCAT there. So get ahead of the game and learn SYSIBM names. P.S. Where is Marcus today? I miss him

Here is an example. Note(1): Tested on DB2 9.7 for LUW. So, some modifications may be necessary to run on earlier DB2 version. Note(2): Add WHERE clause or use subquery, to select first 10 rows only. Code: ------------------------------ Commands Entered ------------------------------ WITH tbload(acct_no, rec_no, tran_date) AS ( VALUES ( 1, 1, '2009-10-01') ,( 1, 2, '2009-10-02') ,( 1, 3, '2009-10-05') ,( 1, 4,...

Are these 32 or 64 bit machines? What are the DBM and DB parameter settings? Andy

Quote: Originally Posted by Lenny77 blank remains blank No problem! Assuming the shift amount remains +19 ... values(translate('gxp rhkd ihlm mhwtr', substr(lower('ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJ KLMNOPQRSTUVWXYZ'), mod(26000001+19,26),26)||' ',lower('ABCDEFGHIJKLMNOPQRSTUVWXYZ '))) 1 ------------------- zqi kadw baef fapmk 1 record(s) selected.

Seems that no body paid much attention on that. Any way, I am splitting script in sections. Code: db2 -tvf script1.sql db2 -mtvf script2.sql db2 -tvf script3.sql That works already. My point to share was to find if anybody had any better workaround. I still need another workaround for Task Center Schedules. Thanks for your attention. DBFinder