Mar 13, 2016
· 2 minute read
databasedb2
Recently spent some time restoring large (~800GB) database direct from TSM.
First step was to get TSM configured for a restore onto a different server.
Second step, grant access to the backup (on the source server);
52> db2adutl grant all on all for database SID A bit permissive but it works in our closed environment.
After that we should be able to query backups on the target server.
For me, options specifying the source node and owner were needed;
Read On →
Mar 13, 2016
· 1 minute read
windows
While it is possible to make and RDP connection from Windows Home/Standard edition to another computer it is not possible to make an RDP connection to either of those versions.
That had put a bit of a spanner in my plans for reorganising my home network as I want to connect remotely to my Windows 8 Standard desktop.
Enter Thinstuff who have created a variety of products for connecting to computers using RDP; for my purposes their Remote Desktop Host was perfect.
Read On →
Mar 13, 2016
· 3 minute read
windowssql server
Control the SQL Server services on a remote server by using SC.
sc \\remote-server-name config MSSQLSERVER start= disabled sc \\remote-server-name stop MSSQLSERVER 4:3:14 "MS Patching 20160123" [SC] ControlServiceEx FAILED 1051: A stop control has been sent to a service that other running services are dependent on. E:\DBA> sc \\remote-server-name enumdepend MSSQLSERVER [SC] EnumDependentServices: entriesread = 1 SERVICE_NAME: SQLSERVERAGENT DISPLAY_NAME: SQL Server Agent (MSSQLSERVER) TYPE : 10 WIN32_OWN_PROCESS STATE : 4 RUNNING (STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN) WIN32_EXIT_CODE : 0 (0x0) SERVICE_EXIT_CODE : 0 (0x0) CHECKPOINT : 0x0 WAIT_HINT : 0x0 :: STOP (and START) commands are asynchronous - might want to use START /WAIT to process them :: e.
Read On →
Mar 13, 2016
· 2 minute read
linux
Setting up user equivalence between two servers.
OK, I didn’t exactly learn this today but I don’t do this often enough to remember it.
It was just time to make my notes a bit more permanent.
Two important do’s -
Do disable remote access to the root account.
Do not do this for the root user.
Create required directory and set permissions $ cd ~ $ mkdir .
Read On →
Mar 10, 2016
· 1 minute read
windowsjekyll
How to install Jekyll on Windows
Three steps:
Install Chocolatey
From a command prompt:
@powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))" && SET PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin Install Ruby choco install ruby -y
Install Jekyll gem install jekyll