Skip to main content

Daghosoft

  • Home
  • My Music

Tag: awk

Generate command list for all instance’s Dbs

October 9, 2013October 9, 2013 Andrea Matera Leave a comment

-) Step 1 : this scrip is an example to prune all logs and backup of a db.

#################### prune.sh
db2 connect to $1
db2 PRUNE HISTORY 20131007 AND DELETE

 

-) Step 2 : generate a command list to prune object for all Dbs in the instance

db2 list database directory | grep alias | awk ‘{print “./prune.sh ” $4}’ > cmdlist

Andrea Von Matera | Crea il tuo badge

My Linkedin Profile

Tags

apache awk backup bash script collaboration config connections connections pool daemon database db2 developing Developing Tool disk management htaccess htpasswd http apache ibm IHS imagemagik iwidget java java utils jdk lan LDAP linux mysql portal prune resource script security service setup social ssh ssh tunnel subversion swap system admin webdav websphere websphere portal wmm

Archives

Friends

  • Cristian Pifferi
  • Factor-y.com
  • Gualtierotesta.it
  • Msbiro
  • Msbiro.net
  • Razioni-k.net2action.com
  • Thisisjack.com

Projects

  • DaghDocs V1.0
  • DaghDocs V2.0
  • SuffissoCore.com
Privacy Policy
Licenza Creative Commons
Quest'opera è distribuita con Licenza Creative Commons Attribuzione - Non commerciale - Condividi allo stesso modo 4.0 Internazionale.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
sparkling Theme by Colorlib Powered by WordPress
Questo sito o gli strumenti terzi da questo utilizzati si avvalgono di cookie necessari al funzionamento ed utili alle finalità illustrate nella cookie policy. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie, consulta la Cookie Policy.
Chiudendo questo banner, scorrendo questa pagina, cliccando su un link o proseguendo la navigazione in altra maniera, acconsenti all’uso dei cookie.Accept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.