spider007
Last Activity: Oct 8 '08, 07:27 PM
Joined: Jan 2 '07
Location:
-
Is there any specific reason that you want a shell script. You can do a export of the table data using EXPORT command. -
What you can try to do is a concat and then cast it as a date. so it should look something like:
concat (char(dat), char(month), '01')
and then u can use date while comparing
date(concat (char(dat), '-',char(month), '-','01') )
I am not sure whether this will work or not. but worth a try. other experts can also responseLeave a comment:
-
Basically what you are looking for is federation. Look at this article http://www.ibm.com/developerworks/db2/library/techarticle/0203haas/0203haas.htmlLeave a comment:
-
the reason it is updating all the rows is that because you have mentioned EXISTS in the wehere clause. So even if one rows exists, it will update all rows. You may want to try:
UPDATE TABLE_HDR
SET HDRFIELD1 = 'XX'
WHERE HDRFIELD1 IN (SELECT HDRFIELD1 FROM TABLE_HDR,TABLE _1A,TABLE_1B WHERE FIELD_1A= FIELD_1B AND HDRFIELD1=FIELD 1A)
this is not performance tuned at all.Leave a comment:
-
You will have to install DB2 on other machine too. Response file helps you in automating the install process. The options which you selected while installing the first time would be saved in the response file. So next time when you install DB2 on any other machine, you can specify the response file at that time and DB2 will be installed with those options.Leave a comment:
-
1. We relate caching to bufferpool. The data is "cached" in a bufferpool, the memory for which is taken from real memory
2. You need to specify the stored procedure as non-fenced. In non-fenced mode, the stored procedures are run in the db2 addresspace, however this is not advisable as if there is any problem with SP, it may result into crashing of the instance.Leave a comment:
-
DB2 agent is the process which is responsible for carrying out work (be it executing SQL, etc.). Going forward in DB2 9.5, DB2 agent is a thread.Leave a comment:
-
i would suggest book by Rogers SandersLeave a comment:
-
DB2 Best Practices
This is not a question.
Just wanted to let everyone know (who don't know till now :)) that there are certain DB2 Best Practices which are published here:
http://www.ibm.com/developerworks/db2/bestpractices.
Your comments/feedback/suggestions are welcome.
-Saurabh -
If you are migrating to DB2 9, you can use compression to actually get the compressed data which will definitely be less than 300GLeave a comment:
-
I thought if you "have Desigined a product using DB2", you would want to still work on DB2 and that is what I want to understand (if you could share, that is), that what could be the possible reason to move to Oracle?
Regd the migration strategy, well as I said, this is probably the wrong forum ;)
-SaurabhLeave a comment:
-
Aren't you asking the wrong question in this forum ;) ?
Just curious to know any particular reason to move from DB2 to Oracle.Leave a comment:
-
I am not very sure, but i think you can create a c function (udf) and then use it in some trigger on that table. Again i am not sure whether udf can be called inside a trigger or notLeave a comment:
-
Did you migrated the database before using it?Leave a comment:
-
Import utility is just like insert statements and hence wil take some time. Load, on the other hand, is very fast but you will not be able to commit after every 2000 rows. if there is no req for commiting every 2k rows, you can use load.
You may also want to look at this article: http://www-128.ibm.com/developerworks/db2/library/tips/dm-0403wilkins/
Oldie but goldie..Leave a comment:
-
I found a link for version 8
http://publib.boulder. ibm.com/infocenter/db2luw/v8/index.jsp?topic =/com.ibm.db2.udb .doc/admin/c0004926.htm
you may also want to look at this article:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707schurr/index.htmlLeave a comment:
-
A little search on info center fetched this
http://publib.boulder. ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb .doc/core/r0002585.htmLeave a comment:
-
I think you will have to modify the tab delimited file to a csv or any other delimiter. For example, if the delimiter is "^", then you can use
db2 import from filename of del modified by coldel^ insert into ....Leave a comment:
-
Keep in mind though that you will have to create a tablespace and a bufferpool of size 32K if you want to use varchar of that size.
Also, I am not really sure whether it will accept 32767.Leave a comment:
-
db2ckbkp is the commandLeave a comment:
No activity results to display
Leave a comment: