Rui Miguel Feio

How to check which RACF datasets are in use

16th August 2009 Rui Miguel Feio

Knowing the names and locations of the RACF datasets that are currently being used by the system is quite easy. For this we have to use the command TSO RVARY Example: TSO RVARY Returns: RACF DATABASE STATUS: ACTIVE USE NUM VOLUME DATASET —— — — —— ——- YES PRIM 1 […]

How to check who’s allocating a device unit

16th August 2009 Rui Miguel Feio

Let’s say for instance that you have a DASD volume (TSTCT1) and you would like to know who’s using it (allocating it). In order to do this we first need to know the unit address of said device: /D U,VOL=volume_name In our example: /D U,VOL=TSTCT1 Result: RESPONSE=TST1 IEE457I 09.53.10 UNIT […]

How to move a WordPress site to a different Server or URL

8th August 2009 Rui Miguel Feio

Moving a WordPress site from one server to another or to a different Web address (URL) may seem a daunting task and something to stay away from. The truth is that it is quite simple! Last month I was asked to help moving a WordPress (WP) blog from one server […]

How to select the First row from a MySQL table

6th July 2009 Rui Miguel Feio

You can use the following command to get the first row from a MySQL table: SELECT * FROM table LIMIT 1 Explanation: table – table name By limiting the returns to 1 (LIMIT 1) we get the first row from the table. Example: SELECT * FROM tusers LIMIT 1

How to select the Last row from a MySQL table

6th July 2009 Rui Miguel Feio

You can use the following command to get the last row from a MySQL table: SELECT * FROM table ORDER BY field DESC LIMIT 1 Explanation: table – table name field – table field This command orders the table by DESCENDING order and limits the number of rows returned to […]