PostgreSQL Configurations

Configurations save in postgresql.conf , Located in <postgresqlFolder>\12\data.

Configurations can be set:
Edit postgresql.conf file itself.

• Via postgres command in the command-line.
• Some parameters can be changed in individual SQL sessions with the SET command.
• Some parameters can be changed with “ALTER SYSTEM” command.
• ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }
• ALTER SYSTEM RESET configuration_parameter
• ALTER SYSTEM RESET ALL

Configurations can be viewed:

• select * from pg_settings
• At pgAdmin.

SQL Server on GCP - You do not have permission to run the RECONFIGURE statement

Error message:

Msg 15247, Level 16, State 1, Procedure sp_configure, Line 105 [Batch Start Line 0]

User does not have permission to perform this action.

Msg 5812, Level 14, State 1, Line 2

You do not have permission to run the RECONFIGURE statement.

The case:

Trying to set configurations (sp_configure and RECONFIGURE)

Solution:

There are no permissions to run sp_configure and RECONFIGURE.

Configuring database flags is done in the GCP portal.

MySQL - see or/and change how many connections can connect to a MySQL instance

 # see the value:
show global variables like 'max_connections';

# Change the value:
SET GLOBAL max_connections = 250;
or in the cnf file property "max_connections".

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

Linux: show enviroment parameter

Show environment parameter <PARAM_NAME> on Linux:

echo $<PARAM_NAME>

example: echo $PATH 

SAP ASE (Sybase) interfaces-sql.ini File

Windows:
sql.ini in <SAP_ASE_FOLDER>\ini

Linux:
<SAP_ASE_FOLDER>/interfaces


Looks like:

Linux:

MYSERVER
master tcp ether MyServer 5000
query tcp ether MyServer 5000

MYSERVER_BS
master tcp ether MyServer 5001
query tcp ether MyServer 5001

...

Windows:
[MYSERVER]
master=TCP,137.116.163.160,5000
master=TCP,137.116.163.160,5000

[MYSERVER_RS]
master=TCP,13.70.20.172,11753
query=TCP,13.70.20.172,11753

...

SAP ASE (Sybase): Collection of monitoring data requires enable monitoring

Error Message while try to run queries for SAP ASE server:
Collection of monitoring data for <OBJECT> requires that the 'enable monitoring' configuration option(s) be enabled. 

Solution:
sp_configure 'enable monitoring', 1