Recent content by qyllr

I found my own answer. It doesn't seem like there is a rollback feature for Windows. I did find documentation for AIX. Thanks anyway, q.

Hello, I'm planning to apply Fixpak 12 on Win 2003 server with DB2 V8.1 Fixpak 7a. Does anyone know if there are any documentation on rolling back Fixpak 12? I was told that there is an option to 'not commit', but I haven't seen the documentation. Any help would be greatly appreciated...

I was able to fix the problem. I just bounced the DAS (Database Administration Server) C:\PROGRA~1\SQLLIB\BIN>db2admin stop SQL4407W The DB2 Administration Server was stopped successfully. SQLSTATE=00000 C:\PROGRA~1\SQLLIB\BIN>db2admin start SQL4406W The DB2 Administration Server was...

Hello, I created backup jobs that dump the backups from WINNT to a Sun box through a WINNT mapping using Samba. I used the Task Center to schedule the backup jobs using the OS command script type. All the backups ran fine with the exception of one which I forgot to specify the folder name in...

hello, try sybperl... hth, q.

hello, try.... sp_help sp_helpdb sp_who hth, q.

thanks anyway... i found the solution... dxxadm is not a sql script... it's a batch file in c:\Program File\SQLLIB\BIN... i was running it in the db2 command line... it should have been executed under .cmd. thanks, q.

hello, i am trying to enable the XML extender by running the following command: dxxadm enable_db DATABASE; but i keep getting the following error: SQL0104N An unexpected token "enable_db" was found following "dxxadm ". Expected tokens may include: "JOIN...

hello, if you are doing it in unix... you can write a shell script and then use CRON to schedule the job... in windows you need to write a batch job and then schedule the job with WINAT... hth, q.

hello, i have done a similar task before, and i used bcp and perl... this procedure is assuming that u are bcp'ing out from database A and bcp'ing to database B tables... which means we are truncating database B tables... 1. bcp out the data from database A table 1... 2. run perl script to...

hello, try using a trigger... hth, q.

hello, this is really easy with regex in perl... if you are interested in this solution go do a google search on cpan and check out patterm matching and regular expressions... if you want a sample script let me know... i'll post one... hth, q.

hello, i was financial with sec... now with a consulting firm doing govt. projects... majority of the projects are using db2 and/or oracle... a good number of them came from sybase... as i mentioned, people i've worked with and gone to training have expressed changing to db2... this is merely...

hello, just wanted to share what fellow sybase dbas are doing... i recently went to sybase training... and the majority of the class attendees are jumping ship and going with db2... as for myself i find myself in a db2 project... as far as my area which is washington, dc... i'm seeing a...

hello, it is also transact sql... it is basically the same between sybase and ms sql... the o'reilly transact sql programming book is excellent on identifying the minor differences between ms sql and sybase transact sql, and it is great for your programming needs... also check out chapter 2...