Search results for query: *

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...

hello, 1. if you have a DOL table, you may see this due to page splitting, inserts and deletes... i think sybase does not guarantee that the results be sorted... 2. i believe the optimizer will choose the best scenario with less i/o... you may be specifying a big range that forces the optimizer...

hello, try using set rowcount... set rowcount 10 while exists (select 1 from tableName where ...) begin delete tableName where ... end go hope this helps, q.

hello, please note that i have a unix platform: i do the following on the command line: 1. run the db2bak utility to backup the file. 2. compress the directory generated by db2bak. 3. copy the directory to the target server. 4. uncompress the directory. 5. run the bak2db utility to restore...

hello, i use 3.1 on a unix platform and all i do is copy two config files from the source config directory to the target config directory... the following are the two files: slapd.user_at.conf slapd.user_oc.conf try to find the netscape software package and get the admin guide file found in...

hello, look into the ports you are using... previously and if you have a new one... and see if it's good... if you are using firewalls, look into your firewall rules and policies and make sure you are allowing access to your new ip and port... hth, q.