Posts

Showing posts from December, 2023

Postgres: To spool to a file and call a SQL script

 cfprod-> \o h:/ps2.txt cfprod-> \i h:/input.sql cfprod-> \o
Post a Comment
Read more

Db2: Get DB size

 [prd1ins1@db2prd601  ~] $ db2 connect to wcprd1    Database Connection Information  Database server        = DB2/LINUXX8664 11.5.8.0  SQL authorization ID   = PRD1INS1  Local database alias   = WCPRD1 [prd1ins1@db2prd601  ~] $ db2 "call get_dbsize_info(?,?,?,-1)"   Value of output parameters   --------------------------   Parameter Name  : SNAPSHOTTIMESTAMP   Parameter Value : 2023-12-07-14.49.14.111291   Parameter Name  : DATABASESIZE   Parameter Value : 117597786112   Parameter Name  : DATABASECAPACITY   Parameter Value : 412211273728   Return Status = 0 [prd1ins1@db2prd601  ~]
Post a Comment
Read more