OnDemand User Group
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Search
Calendar
Login
Register
OnDemand User Group
»
Tips and Tricks
»
Tips and Tricks
»
Unloading a bunch of reports at once
« previous
next »
Print
Pages: [
1
]
Author
Topic: Unloading a bunch of reports at once (Read 6890 times)
frasert
Guest
Unloading a bunch of reports at once
«
on:
March 30, 2011, 01:27:03 PM »
CMOD 8.4, AIX
If you need to unload lots of reports for a given app group, you need not do them manually one-by-one. This is the method I use:
-Go to the System Log and search for msg number 87 for the reports you want to unload.
-Copy the Message column that includes the Load ID and paste the contents into your favorite text editor.
-Strip out everything but the Load ID for each line (TextPad makes this easy).
-Copy the contents of this file and paste it into a new file on your AIX server called 'loadids'.
-Run this command:
# corrected per Alessandro....
$ while read loadid ; do arsadmin unload -h server -u userid -p passwd -g AppGroup -L $loadid ; done < loadids
DONE!
Of course, once the number of reports to unload reaches a size that's unmanageable for simple copy/paste, you'll have to find another way to produce the loadids file.
«
Last Edit: March 31, 2011, 07:45:54 AM by frasert
»
Logged
Alessandro Perucchi
Global Moderator
Hero Member
Posts: 1002
Re: Unloading a bunch of reports at once
«
Reply #1 on:
March 31, 2011, 01:11:24 AM »
Well your online command is wrong!! :-D
I'll correct it for the future generation !! :-D
while read loadid ; do arsadmin unload -h server -u userid -p passwd
-g
AppGroup -L $loadid
; done
< loadids
Otherwise, nothing to say!
Cheers,
Alessandro
Logged
Alessandro Perucchi
#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML
frasert
Guest
Re: Unloading a bunch of reports at once
«
Reply #2 on:
March 31, 2011, 07:42:46 AM »
Oops, thanks Alessandro for the correction!! That's what happens when I rush through a post!
Logged
Alessandro Perucchi
Global Moderator
Hero Member
Posts: 1002
Re: Unloading a bunch of reports at once
«
Reply #3 on:
March 31, 2011, 08:07:46 AM »
Well, I have another correction :-D
You said, that it was for AIX... I would say it's for UN*X (meaning : AIX, Linux, Solaris, HP)
Cheers,
Alessandro
Logged
Alessandro Perucchi
#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML
frasert
Guest
Re: Unloading a bunch of reports at once
«
Reply #4 on:
March 31, 2011, 11:08:18 AM »
Right, it probably works for other environments. I was just stating what environment we are using. Thanks.
Logged
Print
Pages: [
1
]
« previous
next »
OnDemand User Group
»
Tips and Tricks
»
Tips and Tricks
»
Unloading a bunch of reports at once