Author Topic: Updating multiple Indexs  (Read 2948 times)

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Updating multiple Indexs
« on: March 26, 2018, 07:10:57 AM »
Hi....We have been given the task of updating over 12,000 Application indexes...They all contain a line referencing and exit that is no longer needed...Our only means we know of to do this is open the ADMINISTRATOR thick client and going into each Application and then the INDEXER INFORMATION tab and manually removing this one line.  Its the same for each one.  Does anyone know if a way to somehow do this systematically or is this the only way?...Again, our group only has access to do this  via the ADMIN client...Appreciate any info.  Take care...DAVE

Nolan

  • Full Member
  • ***
  • Posts: 152
    • View Profile
Re: Updating multiple Indexs
« Reply #1 on: March 26, 2018, 07:19:42 AM »
Are you saying ARSXML is not an option for your team?  ARSXML is the way to go. 

1. ARSXML to unload
2. Use a script to delete the line in the reports
3. ARSXML to update
J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 576
    • View Profile
Re: Updating multiple Indexs
« Reply #2 on: March 26, 2018, 07:49:51 AM »
What Nolan said. ARSXML and a little bit of basic scripting is your friend here.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Re: Updating multiple Indexs
« Reply #3 on: March 26, 2018, 08:05:21 AM »
Unfortunately the XML option isn't available for us..I'll pass this info onto our engineering team to see what they can come up with...I appreciate the input!!!!!!!...take care

Greg Ira

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: Updating multiple Indexs
« Reply #4 on: March 27, 2018, 05:55:07 AM »
Thinking a little outside the box.  If the exit isn't going to be used by anything else possibly rewrite the exit to do nothing?

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Updating multiple Indexs
« Reply #5 on: March 27, 2018, 06:14:58 AM »
Without the CMOD arsxml utility, your only option to do this in an automated fashion is to write a custom tool that writes the indexer field to a file, changes the file, then replaces the index parameters in the database. 

It would honestly be easier to upgrade to a newer version of CMOD that supports arsxml.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR