Recent content by cougartrace

We have to have a report for all users who have not logged into the database in 45 days? We don't have anything like LDAP (or whatever its called nowadays) so our security is all in the database. Anyone have any hints to help out with this?

I have a script that does DB2 HADR monitoring, however during execution it asks me for the user password - is there anyway to pass that password in the script? DB2HADRDBNAME=TDWD #Get the local DB2 instance name DB2INST=db2tdwd HADRROLE="UNKNOWN" HADRSTAT="UNKNOWN" HADRROLE=$(su - $DB2INST -c...

Just can think right now, If I have a table that looks like the following: X Y = = A 1 B 2 C 1 D 2 What is the query I need to return all X rows where column Y has multiples of the same value?

Anyone know a quick and easy way to have a script to connect to all DB2 UDB databases on 3 different AIX servers to give me a list of all users in the database?

I have Windows XP Media Center Edition. I'm currently using Ghost 10 to backup my computer to my USB drive. I find that ever since installing GHOST my computer takes much longer to startup. Can anyone recommend any other backup software (freeware or otherwise)?

I have a neighbor who's Windows Me won't start in Normal or Safe mode. I ran scandisk and it ran with many errors. Is there anything I can do to help him save his data? How do I force Windows Me to reinstall over itself? I've tried but it keeps telling me I already have the OS installed.

Thanks a bunch. This is much more simple than the way I was trying. CougarTrace

Hi all, If I have a file that looks like this: dallas new york chicago los angeles In a unix script how I can grab one line at a time in that file and email it to someone?

I have this DB2 UDB query: db2 -x "select tsname,pct_free from db2admin.ts_free_space where size_meg > 1 and type = 'DMS' and pct_free <= 97" > show.lst Can someone help me with the unix scripting to parse out the tablespace name and pct free and send a page for each tablespacename?

Can someone help me with a query that will give me the 30 largest tables in a DB2 UDB database? Thanks, CougarTrace

Hi all, In DB2 UDB (were on 8.1 on AIX), how can I get a listing of tables that have a rowcount greater than 100,000? CougarTrace

Anyone have a script to give 10 largest tables in a database? Or a script that would give sizes of all tables in a database?

Hello all, I have a situation where I'm using access to connect to DB2 os390 via DB2 Connect. On the OS390 side, I was required to change my password. However, in access I'm getting the error that it doesn't recognize my id or password when I try to link a new table. It doesn't even prompt me...

Hello all, I have a situation where I'm using access to connect to DB2 os390 via DB2 Connect. On the OS390 side, I was required to change my password. However, in access I'm getting the error that it doesn't recognize my id or password when I try to link a new table. It doesn't even prompt me...

i posted the script