Search results for query: *

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

integer daily daily=`date +%j` dateh=$(date) datet=$(date +"Date: %D Time: %T") curdate=$(date +%Y%b%d_%H:%M) s_name=`uname -n` integer total typeset -i psize psize=0 upsize=0 tpsize=0 pct='85' # Send error message when the tablespace exceeds percent thresh='3221225472' # If...

this script probably not suitable for posting because of length, unfortunately.

this is just a piece of code in a loop where I grate the state of the tablespace among other pieces of info. My problem is that, if the 1st tablespace state is = 0x0000 then it sets the nstate = NORMAL (which is fine), however on the next tablespace, no matter what state is equaled to, it still...

I have this piece of code in my korn shell script: #*********************** # Check TableSpace State #*********************** if [ $state = '0x10000000' ] then nstate = 'BALANCE' elif [ $state = '0x0000' ]...

Hi everyone, We have an excel spreadsheet that we are importing into SQL Server. How can we tell excel that we have 724 rows in the sheet and there is no more after that. When we do the import, we believe it is also taking the blanks fields after 724. Thanks, CougarTrace