Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Southampton, England
    Posts
    4

    Unanswered: Total Novice Requires Help

    I have been asked to look at Perl and it's suitability for carrying out dba tasks. I have no knowledge at all about it - can some kind soul please explain to me how I install and set it up - It will be running on a win2k advanced server with udb v7.2 the client machines are NT4 & win2k Professional with 7.2 clients installed

    thanks in anticipation

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120
    It's a tough job to evaluate something you have no knowledge about! So here some hints:

    Go to www.activestate.com, they distribute Perl for win32.
    Get it and install it, instructions are on the website, it's free.

    Get the database modules you need (DBI and DBD::Db2) using the ppm program, instructions again on the website or meanwhile somewhere on your disk.

    I don't know about a DBI tutorial for beginners at the moment so I can't help you here.

    I'm writing a DBA cookbook at the moment, it's focused on Sybase, but the idea behind the recipes may fit to any DBA's problems. You can take a look and see how simple most tasks can be solved. It can be found here:
    http://www.widd.de/bernd/cookbook/sy..._cookbook.html

    If you want to start programming Perl, there's a lot of information on the web:
    www.perlmonks.org is a very good Perl community with lots of tutorials.

    At perltraining.com.au/notes.html you will find training material for beginners Perl courses.

    perl.oreilly.com has a set of very good Perl books, including one about database usage.

    Perl itself comes with a huge documentation but it isn't easy to learn Perl with it, try perldoc perl on the command line and have a look.

    Each module has it's own documentation, so when you have installed DBI and DBD::Db2 have a look at it:
    perldoc DBI and perldoc DBD::Db2 on the commandline.

    In my opinion Perl is the best language for DBA tasks:
    It can connect to about any database on earth, it's fast, it's relatively simple, it helps you to solve you problems fast (it's semi interpreted, so you don't need a compiler) and it has lots of other advantages over java or c.

    I hope that's enough to get you started.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •