Compartilhando conhecimento com o mundo

Com tecnologia do Blogger.

Pesquisa

Download

Blogger Tricks

Blogger Themes

Visitas

Assuntos

10/29/2013

Script para Automatizar as Tarefas no Oracle


Este post pode ser um pouco passado para muitos DBAs, mas para quem está começando e planeja automatizar algumas tarefas, as dicas aqui pode ser de extrema utilidade! Estou começando.

Opção 1;
-------------------------------------------------------------------------------------------------
29/10/2013                        ***** ORACLE BASIC SERVICES *****                      16:14:17
-------------------------------------------------------------------------------------------------
                                    s120.ms - 10.2.19.4 - oracle

         Code  Basic Services                 Code  Basic Services                
         ----  ---------------------------    ----  ---------------------------   
           1   Performance/Desempenho          12   XXXXXXXXXXXXXXXXXXXXXXXXXX   
           2   XXXXXXXXXXXXXXXXXXXXXXXXXX      13   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           3   XXXXXXXXXXXXXXXXXXXXXXXXXX      14   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           4   XXXXXXXXXXXXXXXXXXXXXXXXXX      15   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           5   XXXXXXXXXXXXXXXXXXXXXXXXXX      16   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           6   XXXXXXXXXXXXXXXXXXXXXXXXXX      17   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           7   XXXXXXXXXXXXXXXXXXXXXXXXXX      18   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           8   XXXXXXXXXXXXXXXXXXXXXXXXXX      19   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           9   XXXXXXXXXXXXXXXXXXXXXXXXXX      20   XXXXXXXXXXXXXXXXXXXXXXXXXX  
          10   XXXXXXXXXXXXXXXXXXXXXXXXXX      21   XXXXXXXXXXXXXXXXXXXXXXXXXX    
          11   XXXXXXXXXXXXXXXXXXXXXXXXXX       0   Sair da Aplicacao             
         ----  ---------------------------    ----  ---------------------------   

                Digita um Codigo - 
Opção 1;
-------------------------------------------------------------------------------------------------
29/10/2013                        ***** ORACLE BASIC SERVICES *****                      16:14:39
-------------------------------------------------------------------------------------------------       
                              Instancias Online 3 - 10.2.19.4 - oracle

     Code  Function                            
         ----  ---------------------------    ----  ---------------------------   
           1   SAR - Performance da CPU        12   XXXXXXXXXXXXXXXXXXXXXXXXXX   
           2   Consumo de Memoria              13   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           3   Consumo de Espaco em Disco      14   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           4   Instancias Online               15   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           5   Gerenciando pelo TOP            16   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           6   Monitorando o Uso do Disco      17   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           7   XXXXXXXXXXXXXXXXXXXXXXXXXX      18   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           8   XXXXXXXXXXXXXXXXXXXXXXXXXX      19   XXXXXXXXXXXXXXXXXXXXXXXXXX    
           9   XXXXXXXXXXXXXXXXXXXXXXXXXX      20   XXXXXXXXXXXXXXXXXXXXXXXXXX  
          10   XXXXXXXXXXXXXXXXXXXXXXXXXX      21   XXXXXXXXXXXXXXXXXXXXXXXXXX    
          11   XXXXXXXXXXXXXXXXXXXXXXXXXX       0   Sair da Aplicacao             
         ----  ---------------------------    ----  ---------------------------   

     Digite um Codigo - 
Opção 2;
-------------------------------------------------------------------------------------------------
29/10/2013                        ***** ORACLE BASIC SERVICES *****                      16:14:48
-------------------------------------------------------------------------------------------------
                                    s120.ms - 10.2.19.4 - oracle

clocks            CPU     %user     %nice   %system   %iowait    %steal     %idle
--------------    ----   ------    ------    ------    ------    ------    ------
04:14:49 PM       all     17.15      0.00      0.13      0.25      0.00     82.48
04:14:50 PM       all     20.32      0.00      0.25      0.00      0.00     79.43
04:14:51 PM       all      0.88      0.00      0.00      0.00      0.00     99.12
04:14:52 PM       all      8.00      0.00      0.00      0.00      0.00     92.00
04:14:53 PM       all      2.49      0.00      0.00      0.12      0.00     97.38
Average:          all      9.77      0.00      0.07      0.07      0.00     90.08

Pressione (ENTER) para continuar...
Opção 3;
-------------------------------------------------------------------------------------------------
29/10/2013                        ***** ORACLE BASIC SERVICES *****                      16:15:07
-------------------------------------------------------------------------------------------------
                                    s120.ms - 10.2.19.4 - oracle

--------------- -----     ------ ---------- ---------- ---------- ----------
Size            total       used       free     shared    buffers     cached
--------------- -----     ------ ---------- ---------- ---------- ----------
GB Mem:            47         45          1          0          0         37
MB Mem:         48298      46917       1381          0        246      38548
KB Mem:      49457628   48043296    1414332          0     252688   39473500

Pressione (ENTER) para continuar...
Opção 4;
-------------------------------------------------------------------------------------------------
29/10/2013                        ***** ORACLE BASIC SERVICES *****                      16:15:19
-------------------------------------------------------------------------------------------------
                                    s120.ms - 10.2.19.4 - oracle

+--------+--------+-------------+------------+----------------------------------------------------+
| Total  | Usado  | Disponivel  | % de Uso   | FileSystem                                         |
+--------+--------+-------------+------------+----------------------------------------------------+
| 55G    | 25G    | 28G         | 48%        | /                                                  | 
| 26G    | 0      | 26G         | 0%         | /dev/shm                                           | 
| 2.1T   | 548G   | 1.5T        | 28%        | /u01                                               | 
+--------+--------+-------------+------------+----------------------------------------------------+

Pressione (ENTER) para continuar... 
Opção 5;
-------------------------------------------------------------------------------------------------
29/10/2013                      ***** ORACLE BASIC SERVICES *****                      16:15:31
-------------------------------------------------------------------------------------------------
                                    s120.ms - 10.2.19.4 - oracle

oracle    8915     1  0 Oct20 ?        00:01:18 ora_smon_prd
oracle   29292     1  0 Oct21 ?        00:00:22 ora_smon_trn
oracle   29610     1  0 Oct21 ?        00:00:29 ora_smon_sml

Pressione (ENTER) para continuar...
Opção 6;
-------------------------------------------------------------------------------------------------
29/10/2013                      ***** INFORMIX BASIC SERVICES *****                      16:19:39
-------------------------------------------------------------------------------------------------

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND     
    1 root      15   0 10372  696  584 S  0.0  0.0   0:32.07 init        
    2 root      RT  -5     0    0    0 S  0.0  0.0   0:00.36 migration/0 
    3 root      34  19     0    0    0 S  0.0  0.0   0:00.01 ksoftirqd/0 
    4 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/0  
    5 root      RT  -5     0    0    0 S  0.0  0.0   0:00.16 migration/1 
    6 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/1 
    7 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/1  
    8 root      RT  -5     0    0    0 S  0.0  0.0   0:00.07 migration/2 
    9 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/2 
   10 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/2  
   11 root      RT  -5     0    0    0 S  0.0  0.0   0:00.12 migration/3 
   12 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/3 
   13 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/3  
   14 root      RT  -5     0    0    0 S  0.0  0.0   0:00.06 migration/4 
   15 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/4 
   16 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/4  
   17 root      RT  -5     0    0    0 S  0.0  0.0   0:00.12 migration/5 
   18 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/5 
   19 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/5  
   20 root      RT  -5     0    0    0 S  0.0  0.0   0:00.05 migration/6 
   21 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/6 
   22 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/6  
   23 root      RT  -5     0    0    0 S  0.0  0.0   0:00.09 migration/7 
   24 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/7 
   25 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/7  
   26 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 events/0    
   27 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 events/1    
   28 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 events/2    
   29 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 events/3    

Pressione qualquer tecla para continuar...
Opção 7;
-------------------------------------------------------------------------------------------------
29/10/2013                      ***** INFORMIX BASIC SERVICES *****                      16:17:09
-------------------------------------------------------------------------------------------------

Linux 2.6.18-238.el5 (s120.ms)  10/29/2013

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           5.84    0.00    0.40    0.35    0.00   93.41

Device:         rrqm/s   wrqm/s   r/s   w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sda               5.75     9.55  1.91  1.62    63.37    89.36    43.28     0.06   17.57   3.25   1.15
sda1              0.02     2.19  0.15  1.10     3.42    26.31    23.78     0.02   17.81   5.06   0.63
sda2              5.73     7.36  1.76  0.52    59.95    63.05    53.97     0.04   17.43   2.30   0.53
sdd               0.00     0.00  0.00  0.00     0.00     0.00    10.79     0.00  520.67 520.67   0.01
sde               3.07    26.63 18.45 10.07  4983.20   293.58   185.01     0.04    1.57   0.96   2.74
sde1              3.07    26.63 18.45 10.07  4983.20   293.58   185.01     0.04    1.57   0.96   2.74

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           6.30    0.00    0.50    0.06    0.00   93.13

Device:         rrqm/s   wrqm/s   r/s   w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.00  1.00  0.00     8.00     0.00     8.00     0.00    3.50   2.00   0.20
sda1              0.00     0.00  1.00  0.00     8.00     0.00     8.00     0.00    3.50   2.00   0.20
sda2              0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sde               0.00    25.50  0.00  7.00     0.00   260.00    37.14     0.01    0.71   0.57   0.40
sde1              0.00    25.50  0.00  7.00     0.00   260.00    37.14     0.01    0.71   0.57   0.40

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           0.62    0.00    0.06    0.00    0.00   99.31

Device:         rrqm/s   wrqm/s   r/s   w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sda1              0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sda2              0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sde               0.00    12.50  0.00  5.00     0.00   140.00    28.00     0.00    0.50   0.50   0.25
sde1              0.00    12.50  0.00  5.00     0.00   140.00    28.00     0.00    0.50   0.50   0.25

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           0.00    0.00    0.00    0.12    0.00   99.88

Device:         rrqm/s   wrqm/s   r/s   w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     9.00  0.00  1.00     0.00    80.00    80.00     0.01    5.50   5.50   0.55
sda1              0.00     9.00  0.00  1.00     0.00    80.00    80.00     0.01    5.50   5.50   0.55
sda2              0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sde               0.00     5.00  0.50  2.00     4.00    56.00    24.00     0.00    0.80   0.80   0.20
sde1              0.00     5.00  0.50  2.00     4.00    56.00    24.00     0.00    0.80   0.80   0.20

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           5.43    0.00    0.12    0.06    0.00   94.38

Device:         rrqm/s   wrqm/s   r/s   w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sda1              0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sda2              0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00  0.00  0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sde               0.00    17.50  0.00  6.00     0.00   188.00    31.33     0.01    1.58   0.83   0.50
sde1              0.00    17.50  0.00  6.00     0.00   188.00    31.33     0.01    1.58   0.83   0.50

  +---------------------------------------------------------------------------------------------------------------------+ 
  | O uso alto de um disco pode haver uma maior chance de que um requerimento solicitando os dados do disco ira bloquear| 
  | (parar) ate que o disco estaja pronto para esse processo. A solucao geralmente envolve a divisao de sistemas de     | 
  | arquivos em discos ou arrays, no entanto, o primeiro passo saber se voce tem este problema.                         | 
  +---------------------------------------------------------------------------------------------------------------------+ 

Pressione qualquer tecla para continuar...

Script Completo;
# -----------------------------------------------------------------------------------------------#
# Funcao : Menu para funcoes importantes do Oracle.                                              #  
# Detalhe: Varios scripts para rodar em um menu no Oracle                                        #
# Autor  : Claudemar Martins de Sa                                                               #
# Data   : 24/10/2013                                                                            #
# Fonte  : http://www.vivaolinux.com.br/script/Menu-tarefas-com-SSH                              #
# -----------------------------------------------------------------------------------------------#
 
Principal () {

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                  ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                    $(hostname) - $(hostname -i) - $(whoami)"
echo
echo "         Code  Basic Services                 Code  Basic Services                "
echo "         ----  ---------------------------    ----  ---------------------------   "
echo "           1   Performance/Desempenho          12   XXXXXXXXXXXXXXXXXXXXXXXXXX   "
echo "           2   XXXXXXXXXXXXXXXXXXXXXXXXXX      13   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           3   XXXXXXXXXXXXXXXXXXXXXXXXXX      14   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           4   XXXXXXXXXXXXXXXXXXXXXXXXXX      15   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           5   XXXXXXXXXXXXXXXXXXXXXXXXXX      16   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           6   XXXXXXXXXXXXXXXXXXXXXXXXXX      17   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           7   XXXXXXXXXXXXXXXXXXXXXXXXXX      18   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           8   XXXXXXXXXXXXXXXXXXXXXXXXXX      19   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           9   XXXXXXXXXXXXXXXXXXXXXXXXXX      20   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "          10   XXXXXXXXXXXXXXXXXXXXXXXXXX      21   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "          11   XXXXXXXXXXXXXXXXXXXXXXXXXX       0   Sair da Aplicacao             "
echo "         ----  ---------------------------    ----  ---------------------------   "

echo
echo -n "                Digita um Codigo - "
read OPCAO
case $OPCAO in  
      1) sub_menu_0001 ;;
      0) exit ;;
      *) clear ; Principal ;;
   esac
}

# ======================================================================================================
# Escolhido a opcao 1 - Monitorando a Performance
# ======================================================================================================

sub_menu_0001 () {

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                  ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "------------------------------------------------------------------------------------------------- "
echo "                              Instancias Online $(ps -ef | grep smon|grep -v grep|awk '{print $8}' | wc -l) - $(hostname -i) - $(whoami)"
echo
echo "     Code  Function                            "
echo "         ----  ---------------------------    ----  ---------------------------   "
echo "           1   SAR - Performance da CPU        12   XXXXXXXXXXXXXXXXXXXXXXXXXX   "
echo "           2   Consumo de Memoria              13   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           3   Consumo de Espaco em Disco      14   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           4   Instancias Online               15   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           5   Gerenciando pelo TOP            16   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           6   Monitorando o Uso do Disco      17   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           7   XXXXXXXXXXXXXXXXXXXXXXXXXX      18   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           8   XXXXXXXXXXXXXXXXXXXXXXXXXX      19   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "           9   XXXXXXXXXXXXXXXXXXXXXXXXXX      20   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "          10   XXXXXXXXXXXXXXXXXXXXXXXXXX      21   XXXXXXXXXXXXXXXXXXXXXXXXXX    "
echo "          11   XXXXXXXXXXXXXXXXXXXXXXXXXX       0   Sair da Aplicacao             "
echo "         ----  ---------------------------    ----  ---------------------------   "
echo
echo -n "     Digite um Codigo - "   
   read OPCAO2
   case $OPCAO2 in
      1) OPCAO_00000 ;;
      2) CONSUMO_DE_MEMORIA ;;
      3) ESPACO_DISPONIVEL_NO_SERVIDOR ;;
      4) INSTANCIAS_ONLINE ;;
      5) COMANDO_TOP ;;
      6) IOSTAT_DISCO ;;
      0) clear ; Principal ;;
      *) Opcao Invalida ; echo ; sub_menu_0001 ;;
   esac
}  

# ======================================================================================================
# Abaixo vamos checar a performance do servidor
# ======================================================================================================

OPCAO_00000 () 
{
clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                  ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                    $(hostname) - $(hostname -i) - $(whoami)"
echo
echo "clocks            CPU     %user     %nice   %system   %iowait    %steal     %idle"
echo "--------------    ----   ------    ------    ------    ------    ------    ------"
sar 1 5 | grep "all"
echo
echo -n "Pressione (ENTER) para continuar..."

read MSG
clear
sub_menu_0001

}

# ======================================================================================================
# Abaixo vamos checar o consumo de memoria
# ======================================================================================================

CONSUMO_DE_MEMORIA () 
{

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                  ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                    $(hostname) - $(hostname -i) - $(whoami)"
echo
echo "--------------- -----     ------ ---------- ---------- ---------- ----------"
echo "Size            total       used       free     shared    buffers     cached"
echo "--------------- -----     ------ ---------- ---------- ---------- ----------"
echo -n "GB "
free -g | grep Mem:
echo -n "MB "
free -m | grep Mem:
echo -n "KB "
free  | grep Mem:
echo
echo -n "Pressione (ENTER) para continuar..."

read MSG
clear
sub_menu_0001

}

# ======================================================================================================
# Abaixo vamos checar o espaco disponivel as particoes desse servidor 
# ======================================================================================================

ESPACO_DISPONIVEL_NO_SERVIDOR ()
{
clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                    $(hostname) - $(hostname -i) - $(whoami)"
echo

LOG1="/tmp/espaco_no_servidor_1234_$(whoami)_pode_deletar_1234_1.log"
LOG2="/tmp/espaco_no_servidor_1234_$(whoami)_pode_deletar_1234_2.log"

df -H | grep -vE 'abc:/xyz/pqr | tmpfs |cdrom | Use' | awk '{ print $2 "|" $3 "|" $4 "|" $5 "|" $6 }' > $LOG1

cat $LOG1 | awk -F "|" '{

    t_iso=$1
if ($1 == "|")
{ t_iso=" " }

printf("| %-6s | %-6s | %-11s | %-10s | %-50s | \n",$1,$2,$3,$4,$5)}' > $LOG2


clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                  ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                    $(hostname) - $(hostname -i) - $(whoami)"
echo 
echo "+--------+--------+-------------+------------+----------------------------------------------------+"
echo "| Total  | Usado  | Disponivel  | % de Uso   | FileSystem                                         |"
echo "+--------+--------+-------------+------------+----------------------------------------------------+"
cat $LOG2
echo "+--------+--------+-------------+------------+----------------------------------------------------+"
rm $LOG1
rm $LOG2

if [ $(df -hP | grep -vE 'Filesystem' | awk '{x=$5;sub ("%","",x)}x>70' | wc -l) -eq 1 ]
then

LOG3="/tmp/espaco_no_servidor_1234_$(whoami)_pode_deletar_1234_3.log"
LOG4="/tmp/espaco_no_servidor_1234_$(whoami)_pode_deletar_1234_4.log"

df -hP | grep -vE 'Filesystem' | awk '{x=$5;sub ("%","",x)}x>70 { print $2 "|" $3 "|" $4 "|" $5 "|" $6 }' > $LOG3

cat $LOG3 | awk -F "|" '{
   t_iso=$1
if ($1 == "|")
{ t_iso=" " }

printf("| %-6s | %-6s | %-11s | %-10s | %-50s | \n",$1,$2,$3,$4,$5)}' > $LOG4

echo
echo "                    +---------------------------------------------------------+"
echo "                    |           Particao Com Mais de 70% Utilizacao           |"
echo "                    +---------------------------------------------------------+"
echo
echo "+--------+--------+-------------+------------+----------------------------------------------------+"
echo "| Total  | Usado  | Disponivel  | % de Uso   | FileSystem                                         |"
echo "+--------+--------+-------------+------------+----------------------------------------------------+"
cat $LOG4
echo "+--------+--------+-------------+------------+----------------------------------------------------+"
rm $LOG3
rm $LOG4
fi
echo
echo -n "Pressione (ENTER) para continuar..."
read MSG
clear
sub_menu_0001
}

# ======================================================================================================
# Abaixo vamos ver as instancias que estao online neste servidor; 
# ======================================================================================================

INSTANCIAS_ONLINE ()
{
clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** ORACLE BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                    $(hostname) - $(hostname -i) - $(whoami)"
echo

# ======================================================================================================
# parte comentada - nem todos os servidores terao so as instancias prd, trn e sml 
# se tiver outra nao vai aparecer no display - deixei o comando que mostra tudo;
# ======================================================================================================
#
# LOG1="/tmp/espaco_no_servidor_1234_$(whoami)_pode_deletar_1234_1.log"
# LOG2="/tmp/espaco_no_servidor_1234_$(whoami)_pode_deletar_1234_2.log"
# 
# ps -ef | grep smon | grep -v grep | awk '{print $8}'| awk -F "_" '{print$3}' > $LOG1
#
# cat $LOG1 | awk -F "|" '{
# t_iso=$1
#
# if ($1 == "prd")
#    { t_iso="| prd - Producao     |" }
#
# if ($1 == "trn")
#    { t_iso="| trn - Treinamento  |" }
#
# if ($1 == "sml")
#   { t_iso="| sml - Simulacao    |" }
#
# printf("%-10s\n",t_iso)}' > $LOG2
# echo "+--------------------+"
# cat $LOG2
# echo "+--------------------+"
# echo
# rm $LOG1
# rm $LOG2

ps -ef | grep smon | grep -v grep

echo
echo -n "Pressione (ENTER) para continuar..."
read MSG
clear
sub_menu_0001
}

# ======================================================================================================
# Abaixo vamos gerenciar os processos no Linux com o comando top 
# ======================================================================================================

COMANDO_TOP ()
{
LOG1="/tmp/1234_$(whoami)_pode_deletar_1234_1.log"
clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"

top -b -n 2 | head -n 55 > $LOG1 ; head -n 37 $LOG1|grep -v top | grep -v Cpu | grep -v Mem | grep -v Swap;
rm $LOG1 ; 
echo
echo -n "Pressione qualquer tecla para continuar..."
read MSG
clear
sub_menu_0001
}

# ======================================================================================================
# Abaixo - Monitorar o I/O nos discos
# ======================================================================================================

IOSTAT_DISCO ()
{
clear

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo

iostat -x 2 5

echo "  +---------------------------------------------------------------------------------------------------------------------+ "
echo "  | O uso alto de um disco pode haver uma maior chance de que um requerimento solicitando os dados do disco ira bloquear| "
echo "  | (parar) ate que o disco estaja pronto para esse processo. A solucao geralmente envolve a divisao de sistemas de     | "
echo "  | arquivos em discos ou arrays, no entanto, o primeiro passo saber se voce tem este problema.                         | "
echo "  +---------------------------------------------------------------------------------------------------------------------+ "
echo

echo -n "Pressione qualquer tecla para continuar..."
read MSG
clear
sub_menu_0001
}       

# ======================================================================================================
# Nao remover a linha abaixo
# ======================================================================================================

Principal


10/28/2013

Como Instalar e Rodar o z/OS no Hercules no Windows


Sobre o Hercules z/OS

Apesar de ser tecnicamente possível rodar z/OS (o mais atual dos sistemas operacionais de mainframe) no Hercules, a IBM não permite devido a questões de licenciamento. Ainda assim é possível rodar sistemas operacionais mais antigos que foram liberados pela IBM para domínio público como OS/360, DOS/360, DOS/VS, MVS, VM/370 e TSS/370, mesmo sendo versões de mainframe bem antiga alguns comandos e conceitos são usados nos atuais z/OS.

Hercules rodando o z/OS

O Hércules é gratuíto, já os produtos IBM (z/OS, DB2, CICS, IMS-TM, etc) é outra história, as licenças são carissimas, além de que para nós pobres mortais teríamos que conhecer um pouco de tudo:

- Instalar/Customizar o próprio z/OS;
- Instalar/Customizar o vários produtos: RACF, VTAM, XES, WLM, SDSF, TSO, DB2, IMS-TM, CICS, e uma parafernalha de softwares necessários para deixar o ambiente operacional, nem que seja só para executar um JCL simples (por exemplo: IEFBR14)
- Comandos de operação para: dar IPL, e monitorar o ambiente, aqueles velhos V nnnn,OFFLINE - V nnnn,ONLINE - D A,L - Replay de mensagens, entre outros.


Imagens de uma Instalação do Hercules



Retirando os Aplicativos do Ar



Download da Imagem do z/OS

Clique Aqui - Neste site fala do download;
Clique Aqui - Mais detalhes sobre a instalação;

Hercules.cnf

# ---------------------------------------------------------------------------------------    
# Configuration file for Hercules & IBM ADCD z/OS 1.6 (HSOTOMA)
# ---------------------------------------------------------------------------------------    
CPUSERIAL 000111       # CPU serial number
CPUMODEL  2064         # CPU model number
MAINSIZE  150          # Main storage size in megabytes 768
XPNDSIZE  0            # Expanded storage size in megabytes
CNSLPORT  3270         # TCP port number to which consoles connect
HTTPPORT  8081         # HTTP server
NUMCPU    4            # Number of CPUs
NUMVEC    2            # Vector facilities emulated
TZOFFSET  +0200 
OSTAILOR  OS/390       # OS tailoring
PANRATE   5000           # Panel refresh rate
ARCHMODE  ESAME        # Architecture mode S/370, ESA/390 or ESAME
PGMPRDOS  LICENSED     # Allow OS/390 and Z/OS systems to run  

# ---------------------------------------------------------------------------------------    
# IPL parameter
# ---------------------------------------------------------------------------------------    

LOADPARM  0A82CS.. 

# ---------------------------------------------------------------------------------------    
# SYMBOLS DEFINITION - COLOQUE ABAIXO O ENDEREÇO DAS IMAGENS DO Z/OS 1.6
# ---------------------------------------------------------------------------------------    

DEFSYM DASD "C:\Mainframe\Imagens_Run\IBM_ZOS_1.6\IBM_ADCD_zOS_v1.6_"    # discos

# ---------------------------------------------------------------------------------------    
# Terminals
# ---------------------------------------------------------------------------------------    

0700    3270
0701    3270
0702    3270
0900    3270
0901    3270

# ---------------------------------------------------------------------------------------    
# DASD
# ---------------------------------------------------------------------------------------    

0A80    3390    $(DASD)z6res1.a80
0A81    3390    $(DASD)z6res2.a81
0A82    3390    $(DASD)z6sys1.a82
0A83    3390    $(DASD)z6uss1.a83
0A84    3390    $(DASD)z6uss2.a84
0A85    3390    $(DASD)z6dis1.a85
0A86    3390    $(DASD)z6dis2.a86
0A87    3390    $(DASD)z6dis3.a87
0A88    3390    $(DASD)z6dis4.a88
0A89    3390    $(DASD)z6dis5.a89
0A8A    3390    $(DASD)z6was1.a8a
0A8B    3390    $(DASD)z6was2.a8b
0A8C    3390    $(DASD)z6db81.a8c
0A8D    3390    $(DASD)z6db82.a8d
0A8E    3390    $(DASD)z6cic1.a8e
0A8F    3390    $(DASD)z6ims1.a8f

# ---------------------------------------------------------------------------------------    
# Tapes
# ---------------------------------------------------------------------------------------    

0550.4  3420 *
0560.4  3480 *
0580.4  3490 *

# ---------------------------------------------------------------------------------------    
# Reader/Printer
# ---------------------------------------------------------------------------------------    

000C    3505     rdr00c.txt ascii trunc
000E    1403     prt00e.txt

#
# CTC link 
#
0E22.2 3088 CTCI 192.168.6.2 192.168.6.1

Alterar a tela de login no z/OS


No ambiente complexo e altamente seguro do z/OS, a tela de login desempenha um papel crucial na autenticação e no acesso aos sistemas mainframe. Embora a interface padrão de login forneça funcionalidade básica, às vezes é desejável personalizar essa experiência para atender às necessidades específicas de uma organização ou para proporcionar uma experiência mais intuitiva aos usuários. A tela estava deste jeito;
z/OS V1R6 Level 0409                               IP Address =
                                                   VTAM Terminal = LCL703

                       Application Developer System

                                //  OOOOOOO  SSSSSSS
                               //  OO    OO SS
                       zzzzzz //  OO    OO SS
                         zz  //  OO    OO   SSSS
                       zz   //  OO    OO       SS
                     zz    //  OO    OO       SS
                   zzzzzz //   OOOOOOO  SSSSSSS


                   System Customization - ADCD.Z16.*




===> Enter "LOGON" followed by the TSO userid. Example "LOGON IBMUSER" or
===> Enter L followed by the APPLID
===> Examples: "L TSO", "L CICS", "L IMS3270
Vai ficar deste jeito
z/OS Z110 Level 0809                               IP Address =
                                                   VTAM Terminal = LCL703

             Application Developers Controlled Distribution

    ##    #######   #####  #######     #######      ##  ######   ######
   ####   ##    ## ##   ## ##    ##        ##      ##  ##    ## ##    ##
  ##  ##  ##    ## ##      ##    ##       ##      ##   ##    ## ##
 ##    ## ##    ## ##      ##    ##      ##      ##    ##    ##  ######
 ######## ##    ## ##      ##    ##     ##      ##     ##    ##       ##
 ##    ## ##    ## ##   ## ##    ##    ##      ##      ##    ## ##    ##
 ##    ## #######   #####  #######  # ####### ##        ######   ######

                   System Customization - ADCD.Z110.*

    +------------------+--------------+----------------------------+
    | IBMUSER          | SYS1/IBMUSER |FULL AUTHORITY              |
    | ADCDMST          | ADCDMST      |FULL AUTHORITY              |
    | ADCDA - ADCDZ    | TEST         |LIMITED AUTHORITY(NO OMVS)  |
    | OPEN1 - OPEN3    | SYS1         |UID(0) (NO TSO)             |
    +------------------+--------------+----------------------------+
             Enter "LOGON" ou "L TSO", "L CICS", "L IMS3270"

Observações

1 - O fonte para alterar: ADCD.Z*.VTAM.SOURCE(USSN) - altere e salve;
2 - Submeta este job para recopilar: ADCD.Z*.VTAM.SOURCE(USSNJCL)
3 - Se tiver alguma duvida de como desenhar as letras acesse este site - Clique Aqui
4 - Por fim temos que dar um comando na console habilitar a tela (sem este comando teríamos que dar um IPL para ver a nova tela);

Arquivo Fonte - USSN

O membro ADCD.Z*.VTAM.SOURCE(USSN - esta o fonte que vamos alterar a tela de login, abaixo esta o modelo da minha alteração.
   Menu  Utilities  Compilers  Help

 BROWSE    ADCD.Z110.VTAM.SOURCE(USSN) - 01.17        Line 00000000 Col 001 080
 Command ===>                                                  Scroll ===> PAGE
********************************* Top of Data **********************************
USSN     TITLE '-- ACF/VTAM USS TABLE FOR NONSNA DEVICES'
         SPACE
*/* ------------------------------------------------------------------
*/*
*/*  USS TABLE FOR NONSNA DEVICES ...
*/*
*/*  . CAN USE 3270 CONTROL CHARACTERS
*/*
*/* ------------------------------------------------------------------
         SPACE
USSN     USSTAB   FORMAT=DYNAMIC
         SPACE
LOGON    USSCMD   CMD=LOGON,REP=LOGON,FORMAT=BAL
         USSPARM  PARM=P1,REP=DATA,DEFAULT=' '
         USSPARM  PARM=LOGMODE
         USSPARM  PARM=APPLID,DEFAULT='TSO'
         SPACE
L        USSCMD   CMD=L,REP=LOGON,FORMAT=BAL
         USSPARM  PARM=P1,REP=APPLID,DEFAULT='TSO'

         USSPARM  PARM=LOGMODE
         SPACE
TSO      USSCMD   CMD=TSO,REP=LOGON,FORMAT=BAL
         USSPARM  PARM=P1,REP=DATA
         USSPARM  PARM=LOGMODE
         USSPARM  PARM=APPLID,DEFAULT='TSO'
         EJECT
USSMSG10 USSMSG   MSG=10,BUFFER=(BUF010,SCAN)
BUF010   DS    0H
         DC    AL2(END010-BUF010)
*
         DC    X'F5C7'                                   COMMAND + WCC
         DC    X'11',AL2(((24-1)*80)+(80-1))                 R=24,C=80
         DC    X'1DC8'                           PROTECTED,INTENSIFIED
*
         DC    X'11',AL2(((01-1)*80)+(01-1))                 R=01,C=01
         DC    C'z/OS Z110 Level 0809                    '
         DC    C'           IP Address = @@@@@@@@@IPADDR'
*
         DC    X'11',AL2(((02-1)*80)+(01-1))                 R=02,C=01

         DC    C'                                        '
         DC    C'           VTAM Terminal = @@LUNAME    '
*
         DC    X'11',AL2(((04-1)*80)+(01-1))                 R=04,C=01
         DC    C'             Application Developers Control'
         DC    C'led Distribution'
*
         DC    X'11',AL2(((05-1)*80)+(01-1))                 R=05,C=01
         DC    C'                                        '
         DC    C'                                       '
*
         DC    X'11',AL2(((06-1)*80)+(01-1))                 R=06,C=01
         DC    C'    ##    #######   #####  #######     #######'
         DC    C'      ##  ######   ###### '
*
         DC    X'11',AL2(((07-1)*80)+(01-1))                 R=07,C=01
         DC    C'   ####   ##    ## ##   ## ##    ##        ## '
         DC    C'     ##  ##    ## ##    ##'
*
         DC    X'11',AL2(((08-1)*80)+(01-1))                 R=08,C=01

         DC    C'  ##  ##  ##    ## ##      ##    ##       ##  '
         DC    C'    ##   ##    ## ##      '
*
         DC    X'11',AL2(((09-1)*80)+(01-1))                 R=09,C=01
         DC    C' ##    ## ##    ## ##      ##    ##      ##   '
         DC    C'   ##    ##    ##  ###### '
*
         DC    X'11',AL2(((10-1)*80)+(01-1))                 R=10,C=01
         DC    C' ######## ##    ## ##      ##    ##     ##    '
         DC    C'  ##     ##    ##       ##'
*
         DC    X'11',AL2(((11-1)*80)+(01-1))                 R=11,C=01
         DC    C' ##    ## ##    ## ##   ## ##    ##    ##     '
         DC    C' ##      ##    ## ##    ##'
*
         DC    X'11',AL2(((12-1)*80)+(01-1))                 R=12,C=01
         DC    C' ##    ## #######   #####  #######  # ####### '
         DC    C'##        ######   ###### '
*
         DC    X'11',AL2(((14-1)*80)+(01-1))                 R=14,C=01
         DC    C'                   System Customization '
         DC    C'- ADCD.Z110.*                       '
*
         DC    X'11',AL2(((15-1)*80)+(01-1))                 R=15,C=01
         DC    C'                                        '
         DC    C'                    '
*
         DC    X'11',AL2(((16-1)*80)+(01-1))                 R=16,C=01
         DC    C'    +------------------+--------------+----'
         DC    C'------------------------+            '
*
         DC    X'11',AL2(((17-1)*80)+(01-1))                 R=17,C=01
         DC    C'    | IBMUSER          | SYS1/IBMUSER |FULL'
         DC    C' AUTHORITY              |'
*
         DC    X'11',AL2(((18-1)*80)+(01-1))                 R=18,C=01
         DC    C'    | ADCDMST          | ADCDMST      |FULL'
         DC    C' AUTHORITY              |'
*
         DC    X'11',AL2(((19-1)*80)+(01-1))                 R=19,C=01
         DC    C'    | ADCDA - ADCDZ    | TEST         |LIMI'
         DC    C'TED AUTHORITY(NO OMVS)  |'
*
         DC    X'11',AL2(((20-1)*80)+(01-1))                 R=20,C=01
         DC    C'    | OPEN1 - OPEN3    | SYS1         |UID('
         DC    C'0) (NO TSO)             |'
*
         DC    X'11',AL2(((21-1)*80)+(01-1))                 R=21,C=01
         DC    C'    +------------------+--------------+----'
         DC    C'------------------------+'
*
         DC    X'11',AL2(((22-1)*80)+(01-1))                 R=22,C=01
         DC    C'             Enter "LOGON" ou "L TSO", "L C'
         DC    C'ICS", "L IMS3270"   '
*
         DC    X'11',AL2(((23-1)*80)+(80-1))                 R=23,C=80
         DC    X'1D40'                                     UNPROTECTED
         DC    X'13'                                      INSERTCURSOR
END010   EQU   *
         EJECT
END      USSEND
         END     ,            END OF ASSEMBLY
Depois de alterar em COMMAND no final da página digite SAVE

Copilar - USSNJCL

Este membro você vai copilar o fonte;
  Menu  Utilities  Compilers  Help

BROWSE    ADCD.Z110.VTAM.SOURCE(USSNJCL) - 01.05     Line 00000000 Col 001 080
Command ===>                                                  Scroll ===> PAGE
********************************* Top of Data **********************************
//USSN     JOB ' ','NAME',
//      CLASS=A,MSGCLASS=H,NOTIFY=&SYSUID,
//      MSGLEVEL=(1,1),REGION=0M,TIME=1440
//* ---------------------------------------------------
//*  NONSNA USS TABLE - USSN
//*
//*  TO ADCD.Z110.VTAMLIB
//* ---------------------------------------------------
//ASM EXEC PGM=ASMA90,REGION=1024K,PARM='NODECK,OBJECT'
//SYSPRINT DD SYSOUT=*
//SYSLIB DD DSN=SYS1.MACLIB,DISP=SHR
//       DD DSN=SYS1.SISTMAC1,DISP=SHR
//SYSUT1 DD UNIT=3390,SPACE=(CYL,(20,5))
//SYSUT2 DD UNIT=3390,SPACE=(CYL,(10,1))
//SYSUT3 DD UNIT=3390,SPACE=(CYL,(2,1))
//SYSUT4 DD UNIT=3390,SPACE=(CYL,(2,1))
//SYSUT5 DD UNIT=3390,SPACE=(CYL,(2,1)),DCB=SYS1.MACLIB,
//       DISP=(,PASS)
//SYSLIN DD DSN=&&OBJ(USSN),DISP=(,PASS),
//       SPACE=(CYL,(1,1,1)),UNIT=3390
//SYSIN DD DSN=ADCD.Z110.VTAM.SOURCE(USSN),DISP=SHR
//* ---------------------------------------------------
//LKED EXEC PGM=HEWLH096,COND=(0,LT),
//       PARM=('SIZE=(1000K,100K),NCAL,XREF,LET,LIST')
//SYSPRINT DD SYSOUT=*
//SYSLMOD DD DSN=ADCD.Z110.VTAMLIB,DISP=SHR
//SYSUT1  DD UNIT=3390,SPACE=(6160,(230,760))
//OBJECT  DD DSN=*.ASM.SYSLIN,VOL=REF=*.ASM.SYSLIN,DISP=SHR
//SYSLIN  DD *
 INCLUDE OBJECT(USSN)
 NAME USSN(R)
******************************** Bottom of Data ********************************
Submeter Job Copilador

Rodando o job que vai assemblar o USSN
  Menu  Functions  Confirm  Utilities  Help

BROWSE            ADCD.Z110.VTAM.SOURCE                     Row 00007 of 00011
Command ===>                                                  Scroll ===> PAGE
           Name     Prompt       Size   Created          Changed          ID
sub______ USSNJCL  *Browsed        31  2008/11/06  2015/11/03 01:07:08  IBMUSER
_________ USSN0                   121  2008/11/06  2008/11/06 15:51:57  IBMUSER
_________ USSN1                   117  2008/11/06  2008/11/06 15:51:57  IBMUSER
_________ USSN100                 121  2008/11/06  2015/11/02 22:58:45  ADCDMST
_________ USSN2                   122  2008/11/06  2015/11/03 02:08:11  IBMUSER
          **End**









IKJ56250I JOB USSN(JOB00829) SUBMITTED
***
Depois de um tempo aparece vai aparecer mais uma mensagem
02.21.29 JOB00829 $HASP165 USSN     ENDED AT N1  MAXCC=0 CN(INTERNAL)
***
Rodou - Geralmente RC=0 rodou ok;
  Menu  Functions  Confirm  Utilities  Help

BROWSE            ADCD.Z110.VTAM.SOURCE                     Row 00007 of 00011
Command ===>                                                  Scroll ===> PAGE
           Name     Prompt       Size   Created          Changed          ID
_________ USSNJCL  *RC=0           31  2008/11/06  2015/11/03 01:07:08  IBMUSER
_________ USSN0                   121  2008/11/06  2008/11/06 15:51:57  IBMUSER
_________ USSN1                   117  2008/11/06  2008/11/06 15:51:57  IBMUSER
_________ USSN100                 121  2008/11/06  2015/11/02 22:58:45  ADCDMST
_________ USSN2                   122  2008/11/06  2015/11/03 02:08:11  IBMUSER
          **End**
Comando na Console

Com este comando não precisamos dar IPL para ver;
F VTAM,TABLE,OPTION=LOAD,NEWTAB=USSN
Tela da console com o comando e o resultado;
    *23.33.14 STC00798 *01 DFHPA1909 CICS     DATA 216 IS INVALID FOR KEYWORD
    * CICSSVC=. RESPECIFY KEYWORD AND DATA.
   - 02.22.30           F VTAM,TABLE,OPTION=LOAD,NEWTAB=USSN
     02.22.30 STC00777  IST097I MODIFY ACCEPTED
     02.22.30 STC00777  IST865I MODIFY TABLE COMMAND COMPLETE-TABLE USSN LOADED
     IST864I NEWTAB=USSN, OLDTAB=USSN, OPT=LOAD, TYPE=**NA**














 IEE612I CN=L700     DEVNUM=0700 SYS=ADCD

 F VTAM,TABLE,OPTION=LOAD,NEWTAB=USSN
Alterado a Tela

Abrindo o emulador de telnet, tela disponivel;
z/OS Z110 Level 0809                               IP Address =
                                                  VTAM Terminal = LCL703

            Application Developers Controlled Distribution

   ##    #######   #####  #######     #######      ##  ######   ######
  ####   ##    ## ##   ## ##    ##        ##      ##  ##    ## ##    ##
 ##  ##  ##    ## ##      ##    ##       ##      ##   ##    ## ##
##    ## ##    ## ##      ##    ##      ##      ##    ##    ##  ######
######## ##    ## ##      ##    ##     ##      ##     ##    ##       ##
##    ## ##    ## ##   ## ##    ##    ##      ##      ##    ## ##    ##
##    ## #######   #####  #######  # ####### ##        ######   ######

                  System Customization - ADCD.Z110.*

   +------------------+--------------+----------------------------+
   | IBMUSER          | SYS1/IBMUSER |FULL AUTHORITY              |
   | ADCDMST          | ADCDMST      |FULL AUTHORITY              |
   | ADCDA - ADCDZ    | TEST         |LIMITED AUTHORITY(NO OMVS)  |
   | OPEN1 - OPEN3    | SYS1         |UID(0) (NO TSO)             |
   +------------------+--------------+----------------------------+
            Enter "LOGON" ou "L TSO", "L CICS", "L IMS3270"

Como Ativar a Unidade de Cartucho do Hercules


Ativar a unidade de cartucho/tape

Toda as vezes que eu colocava a unidade de cartucho 560 online ocorria este erro
- 19.10.26           v 560,online
    19.10.26           IEE025I UNIT 0560     HAS NO LOGICAL  PATHS
Para parar de dar este erro foi editado o arquivo hercules.cnf foi colocado assim as unidades;
DEFSYM TAPEDIR "/home/claudemar/hercules-3.07/tapes"
    AUTOMOUNT $(TAPEDIR)
    AUTOMOUNT +/tapes
    AUTOMOUNT -/tapes/vault
    #********************************************************************
    # Unidades de Cartucho/Fita                                         *
    #********************************************************************

    0500 3490 $(TAPEDIR)/ # tape
    0560 3480 $(TAPEDIR)/ # tape
    0561 3480 $(TAPEDIR)/ # tape
    0562 3480 $(TAPEDIR)/ # tape
    0563 3480 $(TAPEDIR)/ # tape
    0564 3480 $(TAPEDIR)/ # tape
#   056A-056E 3480 $(TAPEDIR)/volumes.$(CUU) maxsizeM=170 eotmargin=131072
Tirei os aplicativos do Z/OS foi dado de novo o IPL na console do Hercules depois que tudo estiver no ar de novo de o comando para colocar cada unidade de cartucho online no mainframe
- 19.05.58           v 500,online
      19.05.58           IEE302I 0500     ONLINE
    - 19.06.27           v 560,online
      19.06.27           IEE302I 0560     ONLINE
    - 19.06.53           v 561,online
      19.06.53           IEE302I 0561     ONLINE
    - 19.07.13           v 562,online
      19.07.13           IEE302I 0562     ONLINE
    - 19.07.16           v 563,online
      19.07.17           IEE302I 0563     ONLINE
    - 19.07.20           v 564,online
      19.07.20           IEE302I 0564     ONLINE
display da unidade
- 19.07.47           d u,tape
      19.07.47           IEE457I 19.07.47 UNIT STATUS 010                     C
      UNIT TYPE STATUS        VOLSER     VOLSTATE
      0500 349S O    -R                      /REMOV
      0560 348S O    -R                      /REMOV
      0561 348S O    -R                      /REMOV
      0562 348S O    -R                      /REMOV
      0563 348S O    -R                      /REMOV
      0564 348S O    -R                      /REMOV
      0565 3480 OFFLINE                      /REMOV
      0566 3480 OFFLINE                      /REMOV
      0567 3480 OFFLINE                      /REMOV
      0568 3480 OFFLINE                      /REMOV
      0569 3480 OFFLINE                      /REMOV
      056A 3480 OFFLINE                      /REMOV
      056B 3480 OFFLINE                      /REMOV
      056C 3480 OFFLINE                      /REMOV
      056D 3480 OFFLINE                      /REMOV
      056E 3480 OFFLINE                      /REMOV

  IEE612I CN=C700     DEVNUM=0700 SYS=ADCD


  IEE163I MODE= RD

10/25/2013

Informix - IFX_DIRTY_WAIT=1024


Tentei alterar uma tabela no Informix apareceu este erro
SQL:   New  Run  Modify  Use-editor  Output  Choose  Save  Info  Drop  Exit
Run the current SQL statements.
----------------------- fronteiras@sefaz30 ----- Press CTRL-W for Help --------
alter table nfe_eletronicaadd(nfe_rae_hr_atu datetime year to minute  default null)


242: Could not open database table (dba.nf_eletronica).  
106: ISAM error:  non-exclusive access.
Para poder rodar tive que dar o comando abaixo o Informix aguarda x segundos até a tabela ser liberada e executa o comando
export IFX_DIRTY_WAIT=1024
Depois de dar o comando acima rodei de novo o alter - depois de algum tempo rodando terminou ok;
SQL:   New  Run  Modify  Use-editor  Output  Choose  Save  Info  Drop  Exit
Run the current SQL statements.
----------------------- fronteiras@sefaz30 ----- Press CTRL-W for Help --------
alter table nfe_eletronicaadd(nfe_rae_hr_atu datetime year to minute  default null);


 Table altered.
Explicação desse Erro

After the LOCK TABLE statement with the IN EXCLUSIVE MODE option executes successfully, no other user can obtain a lock on the specified table. When you attempt a DDL operation on that table, however, you might receive RSAM error -106 if the same table is being accessed by a concurrent session (for example, by opening a cursor). This error can also affect implicit locks that certain DDL statements place on tables automatically.

This is possible because table locks do not preclude table access. An exclusive lock prevents other users from obtaining a lock, but it cannot prevent them from opening the table for write operations that wait for the exclusive lock to be released, or for Dirty Read operations on the table. You can set the IFX_DIRTY_WAIT environment variable to specify that the DDL operation wait for a specified number of seconds for Dirty Read operations to commit or rollback.