Archive | June, 2007

DataStage

29 Jun

USEFUL DATASTAGE COMMANDS:
If the DS server is down:
To start:
$> $DSHOME/bin/uv -admin start

To stop:
$> $DSHOME/bin/uv -admin stop

Check how many records there are in a .ds file:
$> dsrecords

Advertisements

db2 basic commands

29 Jun

need to start database manager in db2 before isntalling Information Server
or if it is says “No start database manager command was issued”
$> start database manager

to stop:
$> stop database manager

need to create database “xmeta” in db 2 before isntalltion IS
$> create database xmeta

to start the database you probably need to be the db2inst1 user and then:
$> db2start

need to grant permissions on xmeta to xmeta

 $> grant on  to 
 $> grant DBADM on database to user  # This is if you have already connected to the database
 $> grant DBADM on database xmeta to xmeta   # note the password is used up on the system.. (DBADM is all privileges)

need to create unix user as “xmeta” and password
or if you are on windows, you can do “net use /add” to create a user that db2 can authenticate against

connect to database from within db2
$> connect to user using

disconnet to database from within db2
$> disconnect

list all databases
$> list db directory

list active database
$> list active databases

list or show tables
$> list tables

If you get “SQL1025N The database manager was not stopped because databases are still active.”
$> stop database manager

Try:
$> list active databases

And to stop everything:
$> force application all

To see db2 profile variables”
$> db2set -all
$> db2set -? # for help

You can set these variables:
$> db2set db2comm=tcpip

To see current configuration:
$> db2 get dbm cfg

I was getting the following error when running ‘db2start’:
“SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager funtionality started successfully”
– This was because TCP/IP stuff was not setup properly (i.e. you could not telnet to port 50000).
To fix:
1. $> db2set db2comm=tcpip
2. ensure that /etc/services has a line like: “db2cdb2inst1 50000/tcp” in it
3. $> db2 update database manager configuration using svcename db2cdb2inst1

from: http://www-1.ibm.com/support/docview.wss?uid=swg21009013
Problem
Does DB2® for Linux®, Windows® and UNIX® have something like Oracle's DUAL table?

Solution
Yes, DB2 database products have a dummy table to select against: SYSIBM.SYSDUMMY1.

DB2 database products also support a VALUES statement.

Either of these can be used to query the values of special registers that can tell you the current time or connected user.

For example:

db2 connect to sample

db2 values user

db2 values current timestamp

db2 select user, current timestamp from sysibm.sysdummy1

Problem running Tests against Websphere Process Server

15 Jun

I was receiving the following error “com.ibm.websphere.management.exception.AdminException: Configuration.MissingValidFrom” when trying to run automatically generated Module tests against my WPS.

To fix, i restarted the WPS Server and did a Project->Clean and it worked.

I’m not 100% sure you actually have to restart the Server, maybe a clean is all you need.

Nokia N73 sync with WMP 11

14 Jun

I prefer Windows Media Player to ITunes. It is much faster and can monitor a network share in the background without any slowness (which I think is its greatest feature – as well as being faster to start up).

To get the N73 to be a sync target in WMP, you must connect it using a USB cable (no Bluetooth support for this) and set the phone to “Mass Storage” mode (this will be a pop-up selection on the phone).

When I set the N73 to “Media Player” mode I found that Windows kept popping up with “Found New Hardware” – it would find the hardware, install it, then another “Found New Hardware” bubble would pop up.

Once your phone is installed and WMP is launched, it automagically adds it as a sync target and you can drag and drop songs onto it or do a random selection.

WMP is simpler than ITunes, and I think I actually find it better. With ITunes i never bothered trying to keep playlists in sync with my Ipod – this was probably because I had ~80gig in my library but only a 4 gig Nano. I initially tried having an ‘Ipod’ playlist but gave up because it was too big for my Ipod.

Linux find motherboard model

6 Jun

To get the motherboard model in Linux
(or other hardware information such as CPU info, IDE, SCSI info)

Try these commands:

$> lshw

and

$>dmidecode