\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{jobbygeorge} \pdfinfo{ /Title (openedge-proutil.pdf) /Creator (Cheatography) /Author (jobbygeorge) /Subject (OpenEdge proutil Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{A3A3A3} \definecolor{LightBackground}{HTML}{F3F3F3} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{OpenEdge proutil Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{jobbygeorge} via \textcolor{DarkBackground}{\uline{cheatography.com/125277/cs/38709/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}jobbygeorge \\ \uline{cheatography.com/jobbygeorge} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Not Yet Published.\\ Updated 14th May, 2023.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{3} \begin{tabularx}{5.377cm}{x{1.4931 cm} x{3.4839 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Common Options of Proutil}} \tn % Row 0 \SetRowColor{LightBackground} bigrow & Format a specified number of BI Clusters in one operation. Example: proutil dbname –C bigrow \textless{}\# of clusters desired minus 4\textgreater{} \tn % Row Count 5 (+ 5) % Row 1 \SetRowColor{white} busy & Determines if a database is in use by another OpenEdge process. \tn % Row Count 8 (+ 3) % Row 2 \SetRowColor{LightBackground} \seqsplit{Conv1011/conv1112} & Convert a version 10 database to version 11, or version 11 to version 12. \tn % Row Count 11 (+ 3) % Row 3 \SetRowColor{white} dbanalys & Do a complete analysis of database population and fragmentation for data and indexes. This option is covered in detail in the Performance Tuning chapter. An optional Area name can be specified. Example: proutil dbname –C dbanalys \textless{}area name\textgreater{} \tn % Row Count 20 (+ 9) % Row 4 \SetRowColor{LightBackground} dbipcs & Display shared memory information for all database Brokers on a Unix system. Not supported on Windows. Example: proutil –C dbipcs \tn % Row Count 25 (+ 5) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.74195 cm} x{3.23505 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{cont...}} \tn % Row 0 \SetRowColor{LightBackground} holder & Determine the mode of operation for a database \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} idxbuild & Rebuild and activate one or more indexes. Offline only. \tn % Row Count 5 (+ 3) % Row 2 \SetRowColor{LightBackground} idxcheck & Report index corruption \tn % Row Count 6 (+ 1) % Row 3 \SetRowColor{white} idxfix & Rebuild one or more indexes, or keys. Can be run online or offline. Checks that all keys point to records and that all records have the proper keys \tn % Row Count 12 (+ 6) % Row 4 \SetRowColor{LightBackground} increaseto & Increase selected Broker startup parameters (-B, -L, -aibufs, -bibufs, -Mxs) online (new options appearing in new releases). There is no "reduceto" option. \tn % Row Count 19 (+ 7) % Row 5 \SetRowColor{white} \seqsplit{disablesitereplication} & Disable OpenEdge Replication \tn % Row Count 21 (+ 2) % Row 6 \SetRowColor{LightBackground} dump/ dumpspecified & Binary data dump \tn % Row Count 23 (+ 2) % Row 7 \SetRowColor{white} \seqsplit{enablelargefiles} & Allow database files to exceed the 2gb limit (default in v12) \tn % Row Count 26 (+ 3) % Row 8 \SetRowColor{LightBackground} \seqsplit{enablesitereplication} & Enable OpenEdge Replication \tn % Row Count 28 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.89126 cm} x{3.08574 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{cont...}} \tn % Row 0 \SetRowColor{LightBackground} indexmove / idxmove & Move an index from one Area to another \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} iostats & Report miscellaneous I/O statistics for a database \tn % Row Count 5 (+ 3) % Row 2 \SetRowColor{LightBackground} load & Binary data load. \tn % Row Count 6 (+ 1) % Row 3 \SetRowColor{white} mvschema & Separate data from the schema into separate Storage Areas \tn % Row Count 9 (+ 3) % Row 4 \SetRowColor{LightBackground} tabanalys & Displays space and fragmentation information for all tables in a database. A subset of the dbanalys option. An optional Area name can be specified \tn % Row Count 16 (+ 7) % Row 5 \SetRowColor{white} tablemove & Move a table from one Area to another \tn % Row Count 18 (+ 2) % Row 6 \SetRowColor{LightBackground} truncate bi & Go through crash recovery and then truncate all BI Clusters. Optionally set the BI Cluster size with the –bi option (in 1k units). Optionally set the BI Block size with the –biblocksize option (in 1k units). Example: proutil db –C truncate bi {[}–bi \textless{}cluster size\textgreater{} -biblocksize \textless{}block size\textgreater{}{]} \tn % Row Count 31 (+ 13) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{x{1.89126 cm} x{3.08574 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{cont... (cont)}} \tn % Row 7 \SetRowColor{LightBackground} updateschema / updatevst & Update the Metaschema or VST schema for new versions of OpenEdge \tn % Row Count 3 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}