Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: qyllr
  • Order by date
  1. qyllr

    Fixpak 12 rollback.

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

    Fixpak 12 rollback.

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

    How to remove a task from the Task Center?

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

    How to remove a task from the Task Center?

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

    How many Perl-DBI modules for Sybase ??

    hello, try sybperl... hth, q.
  6. qyllr

    Sybase DB Configuration

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

    XML Extender

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

    XML Extender

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

    Sybase BACKUP

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

    best way to transfer data

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

    Inserting into Table A based on a value in Table B, How?

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

    Editing Part of a delimited message in a field

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

    The future of Sybase

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

    The future of Sybase

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

    Sybase Questions.

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

    Clustered INdex - Strange Behavior

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

    Batch Delete

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

    Need Help with Replicating LDAP Schema

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

    Need Help with Replicating LDAP Schema

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

    Cannot Bind to LDAP Server

    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.

Part and Inventory Search

Back
Top