SQWareCentral:mssql

From Wiki_dbSQWare
Revision as of 06:23, 28 June 2011 by Expdbtools (talk | contribs) (sqwc_ExpVar.cfg)
Jump to: navigation, search

auto

sqwmsq_DeplScripts.ksh

Action script $gvsqw_RootexpdbCentral/action/mssql/auto/sqwmsq_DeplScripts.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/auto_cust/sqwmsq_DeplScripts.ksh.
SQWareProduction deployment for Mssql

Action:

lfsqw_Action()
{
while read lvsqw_HostName lvsqw_UserName
do
echo "${c_info}$lvsqw_UserName@$lvsqw_HostName${c_normal}"
ssh -T $lvsqw_UserName@$lvsqw_HostName <<EOFSSH
mkdir -p $gvsqw_RootSQWareProductionMssql/$gvsqw_VersDeplSQWareProductionMssql
cd $gvsqw_RootSQWareProductionMssql
rm -f $gvsqw_VersSQWareProductionMssql
ln -s $gvsqw_VersDeplSQWareProductionMssql $gvsqw_VersSQWareProductionMssql
EOFSSH
rsync -aHv $gvsqw_RsyncPathMssql --delete $gvsqw_RootSQWareProduction/mssql/$gvsqw_VersDeplSQWareProductionMssql $lvsqw_UserName@$lvsqw_HostName:$gvsqw_RootSQWareProductionMssql/.
done <$gvsqw_TmpFile.lst
}


sqwmsq_GatherIndicators.ksh

Action script $gvsqw_RootexpdbCentral/action/mssql/auto/sqwmsq_GatherIndicators.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/auto_cust/sqwmsq_GatherIndicators.ksh.
Mssql gather indicators

Action:

lfsqw_Action()
{
while read lvsqw_HostName lvsqw_UserName lvsqw_Instance
do
echo "${c_info}$lvsqw_UserName@$lvsqw_HostName $lvsqw_Instance${c_normal}"
ssh -T $lvsqw_UserName@$lvsqw_HostName <<EOFSSH &
. \$gvsqw_MsqBin/../tools/sqwmsq_SetEnv.ksh $lvsqw_Instance
\$gvsqw_MsqBin/sqwmsq_RunJob.ksh -S $lvsqw_Instance -A IndicDba
EOFSSH
sleep 1
done <$gvsqw_TmpFile.lst
wait
}


sqwmsq_RotateLog.ksh

Action script $gvsqw_RootexpdbCentral/action/mssql/auto/sqwmsq_RotateLog.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/auto_cust/sqwmsq_RotateLog.ksh.
Execute RotateErrorLog action

Action:

lfsqw_Action()
{
while read lvsqw_HostName lvsqw_UserName lvsqw_Instance
do
echo "${c_info}$lvsqw_UserName@$lvsqw_HostName $lvsqw_Instance${c_normal}"
ssh -T $lvsqw_UserName@$lvsqw_HostName <<EOFSSH &
. \$gvsqw_MsqBin/../tools/sqwmsq_SetEnv.ksh $lvsqw_Instance
\$gvsqw_MsqBin/sqwmsq_RunJob.ksh -S $lvsqw_Instance -A RotateErrorLog
EOFSSH
sleep 1
done <$gvsqw_TmpFile.lst
wait
}




etc

CrontabRef.cfg

Configuration file $gvsqw_RootexpdbCentral/action/mssql/etc/CrontabRef.cfg:
It contains the operating variables of SQWareCentral for mssql.
If you want to overload default variables,
put in $gvsqw_RootexpdbCentral/action/mssql/etc_cust/CrontabRef.cfg
your modifications (only variables you want to modify).

sqwc_DbRefVar.cfg

Configuration file $gvsqw_RootexpdbCentral/action/mssql/etc/sqwc_DbRefVar.cfg:
It contains the operating variables of SQWareCentral for mssql.
If you want to overload default variables,
put in $gvsqw_RootexpdbCentral/action/mssql/etc_cust/sqwc_DbRefVar.cfg
your modifications (only variables you want to modify).

File content:

export gvsqw_DbRefType_mssql='mssql'
export gvsqw_DbRefPort_mssql='InstancePortForMssql'
export gvsqw_DbRefInstance_mssql='InstanceNameForMssql'
export gvsqw_DbRefDatabase_mssql='DatabaseInstanceNameForMssql'
export gvsqw_DbRefUser_mssql='ConnexionUserForMssql'
export gvsqw_DbRefPass_mssql='ConnexionPassForMssql'
export gvsqw_EgrepiV_mssql='Sun Microsystems|you have'



Variable explanation:

gvsqw_DbRefDatabase_mssql => Database of SQWareRepository for Mssql
gvsqw_DbRefInstance_mssql => Instance of SQWareRepository for Mssql
gvsqw_DbRefPass_mssql => password to connect to SQWareRepository for Mssql
gvsqw_DbRefPort_mssql => Not used
gvsqw_DbRefType_mssql => type of RDBMS for SQWareRepository for Mssql
gvsqw_DbRefUser_mssql => user to connect to SQWareRepository for Mssql
gvsqw_EgrepiV_mssql => to supress trace of ssh connection


sqwc_ExpVar.cfg

Configuration file $gvsqw_RootexpdbCentral/action/mssql/etc/sqwc_ExpVar.cfg:
It contains the operating variables of SQWareCentral for mssql.
If you want to overload default variables,
put in $gvsqw_RootexpdbCentral/action/mssql/etc_cust/sqwc_ExpVar.cfg
your modifications (only variables you want to modify).

File content:

export gvsqw_RootSQWareProductionMssql="~$gvsqw_UserUniqueMssql/SQWareProduction/mssql"
export gvsqw_VersSQWareProductionMssql='prod'
export gvsqw_VersDeplSQWareProductionMssql='v3.1'
export gvsqw_Mail_mssql='dba'
export gvsqw_MailMsg_mssql='TrtMssqlAuto'



Variable explanation:

gvsqw_MailMsg_mssql => begining of email subject for Mssql
gvsqw_Mail_mssql => email adress for Mssql
gvsqw_RootSQWareProductionMssql => SQWareProduction directory source for Mssql
gvsqw_VersDeplSQWareProductionMssql => version of SQWareProduction to deploy for Mssql
gvsqw_VersSQWareProductionMssql => link for current version of SQWareProduction for Mssql


sqwc_GlobalVar.cfg

Configuration file $gvsqw_RootexpdbCentral/action/mssql/etc/sqwc_GlobalVar.cfg:
It contains the operating variables of SQWareCentral for mssql.
If you want to overload default variables,
put in $gvsqw_RootexpdbCentral/action/mssql/etc_cust/sqwc_GlobalVar.cfg
your modifications (only variables you want to modify).

File content:

export gvsqw_UserUniqueMssql='sysdba'



Variable explanation:

gvsqw_UserUniqueMssql => user to deploy SQWareProduction for Mssql


.profile_confort

File to put aliases $gvsqw_RootexpdbCentral/action/mssql/etc/.profile_confort:
Contains confort aliases of SQWareCentral for RDBMS mssql.

Alias explanation:

act_msq => 'cd $gvsqw_RootexpdbCentral/action/mssql/prod;ls -al'
depl_msq => '$gvsqw_RootexpdbCentral/bin/sqwc_TrtAuto.ksh mssql sqwmsq_DeplScripts.ksh sqwmsq_GenLstUnix.ksh NOLOG CONFIRM'
repind_msq => '$gvsqw_RootexpdbCentral/bin/sqwc_TrtAuto.ksh mssql sqwmsq_GatherIndicators.ksh sqwmsq_GenLstRepind.ksh NOLOG'
gen_msq => '$gvsqw_RootexpdbCentral/action/mssql/lst/sqwc_GenRefMssql.ksh'




lst

sqwc_GenRefDbMssql.ksh

List generator $gvsqw_RootexpdbCentral/action/mssql/lst/sqwc_GenRefDbMssql.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/lst_cust/sqwc_GenRefDbMssql.ksh.


Query used:

select 'MSQ;' + vol.Alias + ';' + vol.Database_name + ';' + ref.Env + ';' +
from tsqw_Repository ref, tsqw_GenInfos inf, tsqw_VolDb vol, tsqw_GenHisto hist
where hist.Month = convert(smalldatetime,'01'+substring(convert(char(10),getdate(),103),3,8),103)
    and inf.Alias = hist.Alias
    and inf.Gather_date = hist.Gather_date
    and inf.Alias = vol.Alias
    and inf.Gather_date = vol.Gather_date
    and ref.Alias = inf.Alias
    and ref.Status!='OFF'
    and vol.Database_name not in ('master','tempdb','Northwind','msdb','model','pubs')
    and vol.Database_name not like 'temp%'
order by vol.Database_name, vol.Alias


sqwc_GenRefMssql.ksh

List generator $gvsqw_RootexpdbCentral/action/mssql/lst/sqwc_GenRefMssql.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/lst_cust/sqwc_GenRefMssql.ksh.


Query used:

select convert(char(15),Alias) ++
from tsqw_Repository
order by alias


sqwmsq_GenLstInstance.ksh

List generator $gvsqw_RootexpdbCentral/action/mssql/lst/sqwmsq_GenLstInstance.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/lst_cust/sqwmsq_GenLstInstance.ksh.
Generation of the list of Mssql instances (tsqw_Repository)

Query used:

select '$gvsqw_HostTsql_mssql', '$gvsqw_UserTsql_mssql', alias
from tsqw_Repository
where STATUS = 'ON'
order by alias


sqwmsq_GenLstRepind.ksh

List generator $gvsqw_RootexpdbCentral/action/mssql/lst/sqwmsq_GenLstRepind.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/lst_cust/sqwmsq_GenLstRepind.ksh.
Generation of the list for reprise of indicators (tsqw_Repository/tsqw_GenInfos)

Query used:

select '$gvsqw_HostTsql_mssql', '$gvsqw_UserTsql_mssql', alias
from tsqw_Repository ref
where STATUS = 'ON'
and not exists ( select 1 from tsqw_GenInfos inf
where inf.Gather_date = convert(smalldatetime,convert(char(10),getdate(),103),103)
and ref.alias = inf.alias)
order by alias


sqwmsq_GenLstUnix.ksh

List generator $gvsqw_RootexpdbCentral/action/mssql/lst/sqwmsq_GenLstUnix.ksh:
Can be replaced by $gvsqw_RootexpdbCentral/action/mssql/lst_cust/sqwmsq_GenLstUnix.ksh.
Generation of the list of unix users FreeTds (tsqw_RepositoryFreeTds)

Query used:

select HostName, UserName
from tsqw_RepositoryFreeTds
order by 1,2