This program was developed as a simple replacement for VisualAppel to send the reports on plain text to the local printer. The solution has 2 parts: 1) Window’s Listener Description: Listener on port 8080 and Display a Preview. Requirements: Port 8080 Free, Java 1.8 Use: %JAVA_HOME%\bin\java" -jar printserver.jar 2) PrintJob […]
I have to start saying, I just jump in DB2 world and this is my contribution to another beginners. The list of commands to start to use the DB2 engine. Global Use INSTHOME/sqllib/adm/db2licm -a filename register a DB2 license key by entering the db2licm -l c db2val validar instalacion db2level […]
Les Comparto la App para android que elabore y utilizo para como Timer para las rutinas de box.
There is no excerpt because this is a protected post.
Set of scripts to monitor a Informix’s Instance
The development teams usually forgets calculate the size of databases’s modele. The spreadsheet can help them to make the sizing for each table of the model. You should make some changes: Adjust the Page Size, the acceptable values can be 2,4,8 and 16. At Rows Amount, write the total record […]
Like everything, the life of informix’s tables has some restrictions arround their grown in tree aspects: Avaible space in the dbspace Pages Used in each fragment Number of extents asigned The next query help us to find the tables in the instance, whom are near to touch their limit of […]
There is no excerpt because this is a protected post.
When I need do maintenance task on a SQL Server DataBade, usually run the next steps: use dbname; GO –Full backup of DB BACKUP DATABASE dbname TO DISK = ‘Z:\SQLServerBackups\dbname.bak’ ; GO — Reclaim free space of the data base DBCC SHRINKDATABASE ; GO — verify and repair tables and […]