Ok
there where some wrong Firewall setups after they added 2 new nodes in the ECS. Now I am wondering. Do I have to change someting In the Spectrum Protect konfiguration or dosen't mather If they added new nodes ?

Hi
At the time when I had to Switch the CMOD from a Solaris to Linux there was no TSM for Linux avalable, so I had to do a Migration
from the TSM to a Windows Server Version.

CMOD 10.5 Is running on REL8 and Spectrum Protect on Server 2016 at the moment.

Since we have now some issues  :-\ with the Spectrum Protect running on the Windows Server we made the desission to go back to a REL8 even if it's alot of work again but I guess there will be better performance again between Server and ECS.

Now I am just wondering what you would recomend for the Spectrum Protect Installation or what best practice would be.

CMOD 10.5 running on a seperate REL8 System and also Spectrum Protect on his own REL8 ?
Or would you install the Spectrum Protect on the actual CMOD 10.5 Server so I would have both on one System again ?

This was the case when I was running cmod and tsm on a solaris maybe 15 years ago.

Are there some issues for a migration back to Linux ?

Thanks in advance
for some Opinions

Dani

Ahh this is maybe also worth to ckeck it > user exits
I know that the permission is ok otherwise the Server would not start ... but maybe
we have to check the code again ....

thank's rj

This is also a funny thing i did not try to do an update ....

ANR3763E An error occurred while the catalog file used for client updates was downloading from                 
                          https://public.dhe.ibm.com/storage/tivoli-storage-management/catalog/client/catalog.json

ANR2547E A Centera device (4) reported error "Unknown     
                          error (transid='server/3133732/WRITE_BLOB'),FP_SERVE-
                          R_ERR" during command BlobWrite. (SESSION: 10062) 

Hi JD
I was able to try it again today.
Alessandro was pointing me in the right direction last week and he got me a hint .... ;D

That's what I did for sql oracle to get the right output .... Date in Oracle > 30.06.00 00:00:00.000000000

  while read line
   do
      SQLCMDFIL="${var1}/${SQLDB}_${prjload}_cmdliste.sql"
      SQLOUT="${var1}/${SQLDB}_${prjload}_outliste_${app}"
      SQLUNLD="${var1}/${SQLDB}_${prjload}_unlo_${app}"
   #
   # SELECT 'table_1' AS table_name, COUNT(*) FROM table_1 UNION
      cat ${SQLHEAD} >${SQLCMDFIL}
      echo -e "spool ${SQLOUT}"  >> ${SQLCMDFIL}
      echo -e "select '#',Form,'#',to_char( Date, 'DD.MM.YYYY' ),'#',LB1,'#',LB2,'#',LB3,'#' from "${SQLDB}"."${line}" where code = 99 ;" >>${SQLCMDFIL}
      echo -e "spool off"  >>${SQLCMDFIL}
      echo -e "exit;" >>${SQLCMDFIL}
      sqlplus -s ${Psqluser}/${Psqluserpwd} @${SQLCMDFIL}
      cat ${SQLOUT}.lst >> ${var2}/${AGI}_${AGIA}_report
   done < ${var1}/table.txt

and the result is

# FORM1 # 30.06.2000 #  8576 # 777 #  00000000 # ..... all on the same line

have a nice day
Dani

Quote from: rjrussel on December 20, 2022, 07:46:16 PM
ARS_NUM_DBSRVR = 8 is probably all you need. The likely hood that you will have 100 users hit search at the exact same time is slim to none.

thanks aj I will try this .....

Hi
I have now a mix with the ols and new Date In the cmod Tables ( Segments ) and I don't get the right output out of my Script.

If I do something like this

   while read line
   do
      SQLCMDFIL="${var1}/${SQLDB}_${prjload}_cmdliste.sql"
      SQLOUT="${var1}/${SQLDB}_${prjload}_outliste_${app}"
      SQLUNLD="${var1}/${SQLDB}_${prjload}_unlo_${app}"
   #
   # SELECT 'table_1' AS table_name, COUNT(*) FROM table_1 UNION
      cat ${SQLHEAD} >${SQLCMDFIL}
      echo -e "spool ${SQLOUT}"  >> ${SQLCMDFIL}
      echo -e "select '#',Form,'#',Date,'#',LB1,'#',LB2,'#',LB3,'#' from "${SQLDB}"."${line}" where code = 99 ;" >>${SQLCMDFIL}
      echo -e "spool off"  >>${SQLCMDFIL}
      echo -e "exit;" >>${SQLCMDFIL}
      sqlplus -s ${Psqluser}/${Psqluserpwd} @${SQLCMDFIL}
      cat ${SQLOUT}.lst >> ${var2}/${AGI}_${AGIA}_report
   done < ${var1}/table.txt
   
   Then I have this Output in my File
   
   # FORM1 #                                                                     
       30-JUN-00 12.00.00 AM                                                       #   
         8576 # 777 #   00000000 #

With the  old arsdate format the output was like this

# FORM1 # 30.07.2000 # 8576 # 777 #  00000000 #

Is it possible to get the same output with the new Date Format ??

thanks
Dani

Thank's JD

During the day there are normally 60 -115 but it can be more and with all the user there are still File loads running.

Hi
I have another question about a slow System.

I have to GET documents out of an Applikation and load it again into a new one.
x.ind
x.out
x.res
On the Test System it takes less then 10 sec for 3 loads if I do it the same on the Prod it takes almost 9 min  :o
Also if I take a look at this Documents it takes a long time till they show up ...

It's on a RHAT 8.0/Oracle and the performance was ok so far.

I am searching all over to find the reason .... no luck

If I have the ARS_NUM_DBSRVR=100 < Is this to high ?

d/V10.5/bin $ echo `date` arssockd count: `arssockd -I  DB-p | wc -l`
arssockd count: 111                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`
arssockd count: 111                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`
arssockd count: 111                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`
arssockd count: 116                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`
arssockd count: 115                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`
arssockd count: 111                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`
arssockd count: 111                                     
nd/V10.5/bin $ echo `date` arssockd count: `arssockd -I DB -p | wc -l`

Spectrum Protect is working and Storage S3 should also not be the problem because there where no changes done.

regards dani

Hi
Just a quick question about the Oracle Version.

After the Update from V17 to V19 do I have to run the arsdb commands ?  :o

./arsdb -I DB -efv
./arsdb �uv -I DB
./arsdb -I DB -rfv
./arsdb �sv -I DB

or is this just for the Update from the CMOD Version ...

dani

Hi,
I think I have gained new insights.
I tried now the following parameters:

ShrintToFit, RotateToFit, CutSheet and FixedAutoOrientation = TRUE

Then I opened the OnDemand Client on Win7 there everything works fine now.

Then I opened the OnDemand Client on Win10, there the first afp is correct and also the print works! If I open the afp again, then it isn�t correct in the gui and also the print doesn�t work anymore. I can log out, close the application and wait a few minutes. Log in again and open the afp, it works. As soon as I click on something in the taskbar and then open an afp again, it will no longer be displayed correctly.

Conclusion:

Win7 works by customizing the above-mentioned parameters in the ini-file and switching the view to autosize
Win10 only works on the first document, as soon as the taskbar is used or a print or similar is done, the next documents are no longer displayed correctly.
It seems like Win10 can only access the ini once or something like that�

Does anyone know what the cause of this could be?

Many thanks

Hi Ed
thanks for the replay.
We are in version 9.5.0.11 and we installed
the 10.1.0.3 Client today still the same issue.

kind regards
dani

Hi all,

We have a problem with the client version 9.5.0.8. Before we had the version 9.5.0.3.
The problem is, that we have an application with papersize "A4 wide". Before the upgrade the afp was displayed correctly and could easily be printed.
Since the new version this doesn't work anymore.
I have done the following steps (as suggested by the support):
Changed the paper size to "autosize" and add the following parms in the [MISC] section of the ftdport2.ini file.
- CutSheet=True
- FixedAutoOrientation=True

Now, the afp is displayed correctly in the gui, but it still can not be printed as a4 wide. Even as a pdf it is not created correctly.
I can select in the printer options the orientation "landscape", but then not the whole page is used. It seems to be a format other than A4 wide, something like letter wide.

Does anyone know this problem or knows how this can be solved?

Many thanks

Hi Alessandro it's me Daniel  ;)
I was able to resolve all the problems that I had and now 2 Linux Servers are running with the V9.5 and Oracle

I have still some issues with the hardcoded parts in the scripts but I guess I will solve this problems too

Gruess D�nu  8)

Hi j
there Is not always a manual from IBM for the Linux with Oracle .... It's more learning by doing ;O)
I bet you didn't have the right link for the Oracle DB

just try this once and maybe you can see where the problem is

[root@ lib64]# cd /opt/ondemand/V10.1bin/exits
[root@exits]# ldd ./arsorcle

kind regards
Daniel