RE: Windows Connect to DB2

RE: Windows Connect to DB2

 

  


Guru is a Sanskrit word[India] which means "Teacher".

-----Original Message-----
From: Gasiorowski Richard
[mailto:db2udbdba-ezmlmshield-x18153885.[Email address protected]
Sent: Wednesday, November 29, 2006 12:32 AM
To: LazyDBA Discussion
Subject: RE: Windows Connect to DB2

Does anyone know the meaning to the acronym GURU? It stands for "Great
Understanding Relatively Useless".

-----Original Message-----
From: dbaguru [mailto:db2udbdba-ezmlmshield-x51362539.[Email address
protected]
Sent: Tuesday, November 28, 2006 1:51 PM
To: LazyDBA Discussion
Subject: RE: Windows Connect to DB2

A runstats before a reorg is beneficial in cases where either a clustered
index or a primary key is in place. During the unload phase of a reorg, DB2
will attempt to unload the data in clustered or primary key sequence, and if
stats are up to date, then access path selection will be better influenced.
The sort phase will also run faster if the data is already there, or at
least close.

Nick Bercea

-------------- Original message --------------
From: "Doug Kostelnik " <db2udbdba-ezmlmshield-x8012074.[Email address
protected]

>
> I don't know, maybe a runstats before a reorg will help speed the reorg a
bit.
> I've never done it and don't see the need.
>
> Douglas Kostelnik
> Senior Database Administrator/Architect
>
> -----Original Message-----
> From: michael [mailto:db2udbdba-ezmlmshield-x8806712.[Email address
protected]
>
> Sent: Tuesday, November 28, 2006 12:45 PM
> To: LazyDBA Discussion
> Subject: RE: Windows Connect to DB2
>
> Thanks Mark...I'll put this into a .cmd file and use it Monday morning.
>
> Why the RUNSTATS before the REORG? Um...because I was told to do that.
> :) I didn't know about things like runstats and reorgs, since the
> iSeries does this automatically. When our UDB database performance
> became incredibly bad, I opened a PMR with IBM and they gave me these
> instructions.
>
> > -------- Original Message --------
> > Subject: RE: Windows Connect to DB2
> > From: "Gillis Mark "
> > > > Date: Tue, November 28, 2006 12:32 pm
> > To: "LazyDBA Discussion" <[Email address protected]
> >
>
> > Hi Michael
> >
>
> > What I'd do is put a connect into each DDL file and then have a .cmd
that goes
> >
>
> > DB2CMD /c /w /i db2 -tsvf runstats.ddl > runstats_1.log
>
> > DB2CMD /c /w /i db2 -tsvf reorg.ddlg > reorg_1.log
>
> > DB2CMD /c /w /i db2 -tsvf runstats.ddl > runstats_2.log
>
> > db2rbind DBNAME -l db2rbind.log
>
> >
>
> > Just out of interest; why a RUNSTATS before a REORG? Do you just want a
> comparison to see what the REORG did? I quite often use REORGCHK in those
> circumstances.
> >
>
> > Cheers
> >
>
> > Mark
>
> >
>
> > -----Original Message-----
> > From: michael [mailto:db2udbdba-ezmlmshield-x29145082.[Email address
> protected]
>
> > Sent: 28 November 2006 16:16
> > To: LazyDBA Discussion
> > Subject: Windows Connect to DB2
> >
>
> > Is there anything special I need to think of for Windows scripting? I
have a
> WCS instance and a DB2 instance. I'm not a UDB (iSeries is my
> > flavor) person, but I wrench on it. I do a runstats/reorg/db2rbind thing
every
> week, where I use db2cmd and db2 -tvf. Do I need to do anything special to
put
> it into a .cmd file?
> >
>
> > Thanks!
> >
>
> > > -------- Original Message --------
> > > Subject: Re: connect to db2 for shell unix.
> > > From: "hsteiner"
> > > > > > Date: Tue, November 28, 2006 11:09 am
> > > To: "LazyDBA Discussion" <[Email address protected]
> > >
>
> > > Here is a simple .sh example:
>
> > >
>
> > > CODE:
>
> > > #! /usr/bin/ksh
> > > . $HOME/sqllib/db2profile
>
> > > db2 "connect to DBNAME";
> > > date;
> > > db2 "reorg table SCHEMA.TABLE";
>
> > > date;
> > > echo "reorg complete";
> > > db2 "terminate";
> > >
>
> > > NOTE: The second line "sources" the db2profile. This might be needed
>
> > > for example if a job is CRON'ed
> > >
>
> > > Here is something a little more sophisticated - it assumes a
connection
> exists:
> > >
>
> > >
>
> > > #! /usr/bin/ksh
> > > . $HOME/sqllib/db2profile
> > > LOG=/bb/db2/home/mydir/hal/takeover.log
> > > echo "Hal's Takeover Script starting" >> $LOG; date >> $LOG
> > > status=`db2 activate database DBNAME`; echo "Activate database -
>
> > > status $status" >> $LOG; date >> $LOG
> > > status=`db2 takeover hadr on database DBNAME`; rc=$?
> > > echo "takeover status is $status return code is $rc" >> $LOG; if [ $rc

>
> > > -ne 0 ]; then echo "takeover by force" >> $LOG;
> > > status=`db2 takeover hadr on database DBNAME by force`; echo "Takeover

>
> > > by force issued - status $status" >> $LOG; fi date >> $LOG echo "Hal's

>
> > > Takeover Script complete";
> > >
>
> > > Hope this helps.
> > >
>
> > > Hal Steiner
> > >
>
> > >
>
> > >
>
> > >
>
> > > -----Original Message-----
> > > From: db2udbdba-ezmlmshield-x8907443.[Email address protected]
> > > To: [Email address protected]
> > > Sent: Tue, 28 Nov 2006 9:55 AM
> > > Subject: RE: connect to db2 for shell unix.
> > >
>
> > >
>
> > > Hi gurú...
> > >
>
> > > i need example Execution of script (in terminal unix)...please,
>
> > > please, please
> > >
>
> > > Thank's
> > >
>
> > >
>
> > > pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee.
> > >
>
> > > k=(
> > >
>
> > > Atte.
> > > Daniel Manque.
> > > Analista de sistemas.
> > >
>
> > >
>
> > >
>
> > >
>
> > > ---------------------------------------------------------------------
> > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>
> > > a dba job: http://jobs.lazydba.com To Subscribe :
>
> > > http://www.LazyDBA.com To unsubscribe:
>
> > > http://www.lazydba.com/unsubscribe.html
> > > ______________________________________________________________________

> > > __ Check out the new AOL. Most comprehensive set of free safety and
>
> > > security tools, free access to millions of high-quality videos from
across
> the web, free AOL Mail and more.
> > >
>
> > >
>
> > > ---------------------------------------------------------------------
> > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>
> > > a dba job: http://jobs.lazydba.com To Subscribe :
>
> > > http://www.LazyDBA.com To unsubscribe:
>
> > > http://www.lazydba.com/unsubscribe.html
> >
>
> >
>
> >
>
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba
> job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
> unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
>
> >
>
> > This e-mail (and any attachments) may contain privileged and/or
confidential
> information. If you are not the intended recipient please do not disclose,
copy,
> distribute, disseminate or take any action in reliance on it. If you have
> received this message in error please reply and tell us and then delete
it.
> Should you wish to communicate with us by e-mail we cannot guarantee the
> security of any data outside our own computer systems. For the protection
of
> Legal & General's systems and staff, incoming emails will be automatically

> scanned.
> >
>
> > Any information contained in this message may be subject to applicable
terms
> and conditions and must not be construed as giving investment advice
within or
> outside the United Kingdom.
> >
>
> > The following companies are subsidiary companies of the Legal & General
Group
> Plc which are authorised and regulated by the Financial Services Authority
for
> advising and arranging the products shown: Legal & General Partnership
Services
> Limited (insurance and mortgages), Legal & General Insurance Limited
> (insurance), Legal & General Assurance Society Limited
>
> > (life assurance, pensions and investments), Legal & General Unit Trust
> Managers Limited and Legal & General Portfolio Management Services Limited

> (investments).
> >
>
> > They are registered in England under numbers shown.
> > The registered office is Temple Court, 11 Queen Victoria Street, London
EC4N
> 4TP.
> >
>
> > Legal & General Partnership Services Limited: 5045000 Legal & General
> Assurance Society Limited: 166055 Legal & General (Unit Trust Managers)
Limited:
> 1009418 Legal & General (Portfolio Management Services) Limited: 2457525
Legal &
> General Insurance Limited: 423930
> >
>
> > They are registered with the Financial Services Authority under numbers
shown.
> You can check this at www.fsa.gov.uk/register
> >
>
> > Legal & General Partnership Services Limited: 300792 Legal & General
Assurance
> Society Limited: 117659 Legal & General (Unit Trust Managers) Limited:
119273
> Legal & General (Portfolio Management Services) Limited: 146786 Legal &
General
> Insurance Limited: 202050
> >
>
> >
>
> >
>
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> style='font-size:12.0pt'>

> _____________________________________________________________

> The information transmitted is intended only for the person(s) or entity
to
> which it is addressed and may contain confidential and or privileged
material
> and should be treated as a confidential AAA Auto Club South communication.
If
> the reader of this message is not the intended recipient, you are hereby
> notified that your access is unauthorized, and any review, dissemination,
> distribution or copying of this message including any attachments is
strictly
> prohibited. If you are not the intended recipient, please contact the
sender
> and delete the material from any computer.

>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Disclaimer

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this communication in error, please immediately notify the [Email address protected] and destroy the original message. The recipient should check this email and any attachments for the presence of viruses. Ness has taken every reasonable precaution to minimize this risk, and accepts no liability for any damage caused by any virus transmitted in this email. Ness reserves the rights to monitor and review the content of all messages sent to or from this E-mail address, and store them on the Ness E-mail system.

DB2 & UDB email list listserv db2-l LazyDBA home page