SAP (sybase) ASE - The maximum number of configured devices has been reached

The case:

Creation of a new device.

Error message:

The maximum number <X> of configured devices has already been reached. Please reconfigure 'number of devices' to a larger value and retry disk initialization.

1> disk init name="DdeviceNameLog", physname="/sybvol01/sap16/data/DdeviceNameLog1.dat", size="100M"

2> go

Msg 5162, Level 16, State 1:

Server 'SRSSERVER', Line 1:

The maximum number 20 of configured devices has already been reached. Please reconfigure 'number of devices' to a larger value and retry disk initialization.

Solution:

sp_configure 'number of devices', 30

go

SAP (sybase) RS - rs_init - Could not connect to ID Server Unable to execute query create connection

The case:

Error when adding a new connection using rs_init: 

Could not connect to ID Server Unable to execute query create connection.

Error message:

WARNING: "Could not connect to ID Server 'ID_RS_NAME'."

Press <return> to continue.

SQL Server message: msg 45, level 12, state 0

WARNING: "Could not connect to ID Server 'ID_RS_NAME'."

Press <return> to continue.

Unable to execute query 'create connection to "ASENAME"."DBNAME" s

et error class rs_sqlserver_error_class set function string class rs_sqlserver_

function_class set username "DBNAME_maint" set password *** with log tr

ansfer on' against server 'RS_NAME'.

Press <return> to continue.

Solution:

The ID Server RS is not available:

1. The RS service is down - start it.
2. Network or connections problems.
3. Any other reason

SQL Server: Alternate to msdb.dbo.agent_datetime

 msdb.dbo.agent_datetime converts integer date + integer time values to a datetime value.

Sometimes you won't have permissions to run agent_datetime (For example in the admin user in AWS RDS) - so you'll need an alternative to it.

DECLARE @int_date INT, @int_time INT

SELECT @int_date=20200913, @int_time=155834

SELECT msdb.dbo.agent_datetime(@int_date,@int_time)

SELECT cast(cast(@int_date as char(8))+' '+stuff(stuff(right('000000'+convert(varchar(6),@int_time),6),3,0,':'),6,0,':') as datetime)

select  jh.run_date, jh.run_time, 

msdb.dbo.agent_datetime(jh.run_date, jh.run_time) as 'agent_datetime',

cast(cast(jh.run_date as char(8))+' '+stuff(stuff(right('000000'+convert(varchar(6),jh.run_time),6),3,0,':'),6,0,':') as datetime) as fog_last_run_time

from msdb.dbo.sysjobhistory jh

SAP (sybase) RS - Displays connection data for the Replication Server

In order to displays connection data for the Replication Server, 

connect SRS, and run:

admin show_connections

go

SAP ASE (sybase) - SHUTDOWN is waiting for process(es) to complete

1> shutdown

2> go

5 task(s) are sleeping waiting for ...

4 task(s) are sleeping waiting for ...

SHUTDOWN is waiting for 9 process(es) to complete.

Solution:

shutdown with nowait

Linux: show enviroment parameter

Show environment parameter <PARAM_NAME> on Linux:

echo $<PARAM_NAME>

example: echo $PATH 

Linux - ubuntu - 'apt-get' is ubuntu 'yum'

 Run: 

sudo yum install openssl

Error:

There are no enabled repos.

 Run "yum repolist all" to see the repos you have.

 You can enable repos with yum-config-manager --enable <repo>

Run successfully:

sudo apt-get install openssl

The usual way to install packages on the command line in Ubuntu is with apt-get.

The usual way to install packages on the command line in Red Hat is with yum.

Microdoft Outlook: How to set that an email won't be set as "read" after moving to the next email without really reading it

One good picture is worth more than 1000 words: