All Questions

0
votes
0answers
3 views

db2setup_exec: (core dumped) ${RUNLOCATION?}/${DB2INSTALLER?} ${DB2OPTS?} — DB2_Svr_V10.5_Linux_x86-64.tar.gz

While installing the db2 in linux rhel6 using DB2_Svr_V10.5_Linux_x86-64.tar.gz its failing with segmentation error DBI1191I db2setup is installing and configuring DB2 according to the ...
0
votes
0answers
5 views

select query in postgres stored procedure

I want write a SP in postgres to retrieve the table data. Please assist. I wrote the SP but while executing there is no response
0
votes
0answers
9 views

TPC-H qgen for generating queries

I downloaded the TPC-H benchmarking dataset. I completed the dbgen part of it. I want to generate the Executable Query Text using qgen. I read the README file, not able to understand it properly. I ...
-1
votes
1answer
18 views

Which has better career prospects : PostgreSQL or MySQL?

I am a Senior Oracle DBA. At the moment , my DBA career is not affected by the rise of open source databases. But, It might not stay like this for long. To make my career future proof, which open ...
0
votes
0answers
8 views

Restarting Mysql makes application fast

I have a Drupal 7 application running a large Mysql database. It's built on AWS instance (30GB RAM, 8 CPU). Below is the my.cnf copy. Issue is that my application gets noticeably fast when I restart ...
0
votes
0answers
10 views

SQL Creating Error Log Table Benefits

We are conducting a datawarehouse project, moving data from Staging database to Kimball Data Warehouse. What is the purpose of creating a custom stored procedure Error Log Table? I am seeing a lot ...
0
votes
0answers
9 views

Alert message to remote SQL DB form local SQL DB IF no data from Software application

HI i am looking for a solution for my software application which has local SQL DB for data storage and from the local SQL DB replicate the data in real time to Remote SQL DB for visualizing the data ...
0
votes
0answers
13 views

Postgresql: How to store high-dimensional ( N > 100) vectors and index for fast lookup by cosine similarity?

I am trying to store vectors for word/doc embeddings in a postgresql table, and want to be able to quickly pull the N rows with highest cosine similarity to a given query vector. The vectors I'm ...
1
vote
0answers
9 views

SQL JDBC upgrade from v6.0 to v7.2 causes java.lang.NullPointerException in *some* stored procedure returned recordsets

I am developing a java application onWindows 10 using Eclipse Oxygen and SQL JDBC v7.2 and java 1.8 update 202. My code runs fine when I use SQL JDBC v6.0 (sqljdbc42.jar Jan 2017 and java 8), but ...
0
votes
1answer
14 views

write csv file only after SQL table update, insert, delete

Objective: Write csv file of updated data from sql table only after SQL table update, insert, delete. I've read from the community that I should not do triggers to execute python. I should not run ...
0
votes
1answer
28 views

SQL Server UNION ALL query

I use a UNION ALL query and it outputs 2 rows for the same date. I want to output only 1 row like the second picture. Do I have to use IIF, CASE or else command? The date, time_in, time_out fields ...
1
vote
1answer
22 views

Create login with SID as string

I'm trying to create a login as follows: CREATE LOGIN [Test] WITH PASSWORD='Test123', SID=SID_BINARY(N'S-1-5-21-408552231-458724953-3089381293-513') But no matter what it looks like SID only accepts ...
2
votes
1answer
13 views

Find SSIS package which calls stored procedure

We are trying to catch errors into an Error Log Table, similar to below. We have many Master SSIS packages, calling many stored procedures. Following code will log into the Error Log Table. Is there ...
2
votes
0answers
17 views

Decode URL encoded characters in inline table valued function?

I'm looking for a inline table valued function that decodes URL encoded characters (like %20 for space). reference I see other functions but haven't seen one that is an inline table valued function. ...
1
vote
1answer
17 views

Schema design for products with redundant values

so I was looking some design schemes for storing a Product's quantity of a certain color and variant sizes, @Gilbert Le Blanc gives the perfect scheme for me as answered in this question, and the ...
-1
votes
0answers
22 views

keeping Dev in sync with prod

What is the best method for keeping a Dev environment in sync with a Prod environment (SQL 2014)? We would like to keep 3 full databases in sync
2
votes
1answer
110 views

Calculating total “on row” bytes for each row … the easy way

We want to calculate the total "on row" storage bytes for each row in the table. As we understand it, we must add up the DATALENGTH() of each column while also accounting for NULLs and things like ...
13
votes
1answer
243 views

SQL Server 2017 crashes when backing up because filepath is wrong

I was trying to restore my database and SQL Server kept crashing. I would get a message in SSMS that said there was a network transport error (the connection dropped bc the crash). I checked the logs ...
2
votes
1answer
20 views

How do I keep a SQL Server Profiler trace from jumping to the bottom entry?

When monitoring a trace in SQL Server Profiler, is there a way to prevent it from jumping to the most recent event without pausing the trace? I'm often trying to scroll up and read descriptions of ...
0
votes
1answer
16 views

Oracle: How do i manage two versions of a stored procedure at the same time?

Here is the situation: There are some stored procedures (3 - 5 no's) already in production. we made some changes for a fix. It also involved changes to the code that is using these stored procedures....
1
vote
0answers
17 views

Dynamic JSON path filtering in PostgreSQL 9.6

I have a somewhat odd JSONB structure in my database to accomodate different possible overrides to common fields. The tricky thing is that I want to query based on those overrides. Here's a sample of ...
2
votes
0answers
33 views

Disable and Rename sa, years after build

Answers and comments at a recent popular question Does changing "sa" password require a SQL restart (in mixed mode)? indicate that renaming and disabling sa at build time is a best practice. ...
-4
votes
0answers
24 views

multi-part identifier could not be bound

Anyone help me please. I got so many error multi-part identifier could not be bound SELECT vc_User.UserName, vc_user.EmailAddress, vc_VidCast.VidCastTitle, vc_VidCast.StartDateTime, ...
1
vote
0answers
5 views

MongoDB sharding and zone tag that has a range of 1 key value

Suppose I have a zone tag that has a range of exactly 1 key value, such as the letter A. Further, suppose I assign this zone to two shards. Will the data with a shard key of A be put on both shards? ...
0
votes
1answer
20 views

how do I get extra fields with in a column with calculations

I have a table AR--X with columns as Region, Product type, pofit, Target, 1, 2, 3,....... till 31 ( days ) as columns. In Product type Column, there are fields like Electronic, Plastic, wood, other, ...
0
votes
0answers
10 views

How to insert into a MySQL table column, known its name as string?

I want to insert into a MySQL table (child table) column a certain value(int value). I know that the column name is: 'parent_data_ID' But that column name is got from the following command: SELECT ...
0
votes
0answers
12 views

Recommend a SQL editor that offers automatic statement resolution and control over line endings and encoding

I work with sql files in source control using SQL Squirrel. I use windows while my fellow devs use macs. It seems that sometimes my editor silently converts sql files on my working copy to ANSI ...
0
votes
0answers
22 views

ORA-03114: not connected to ORACLE

I know what I did wrong! While migrating my database from one directory to another based on this amazing article This, at the very last step (alter database rename file 'C:\ORACLEXE\APP\ORACLE\ORADATA\...
0
votes
0answers
6 views

Azure MariaDB log_bin_trust_function_creators

I'm testing AzureDB for MariaDB and for my DB to work properly I must change log_bin_trust_function_creators variabl. However, it isn't available in Azure Portal Server Parameters. I've checked and ...
0
votes
1answer
11 views

Time oriented design in Postgresql

I've been reading Snodgrass's "Developing Time-Oriented Database Applications in SQL" and I'm consulting other documents as well, but I'm willing to find more modern stuff about time-oriented design ...
0
votes
0answers
6 views

Mongodb secondary reads data at 100% 24/7

We have a Mongodb 4.0 database, running a replica set with 3 members. Total database size is about 800GB. All of the members are running in docker containers. Docker shows that the master container ...
2
votes
1answer
37 views

Central Management Server - Query against host server

I like the idea of setting up a Central Management Server to run queries against other servers that I have to maintain. I'd like to be able to run one query to get information from all servers, like ...
-3
votes
3answers
56 views

Incorrect syntax near the keyword 'WHERE' on sql server [on hold]

I tried googling this but every post I find, the OP is using insert or join. Well I am not. I am trying to replace a string in a column, Details where Name = Service1 begin tran UPDATE [User] SET ...
0
votes
0answers
7 views

DB2 reporting incorrect filesystem full error?

DB2 V10.5, RHEL 7.5 We had an issue when DB2 was stuck not being able to write log files to disk because of disk full error just that there was more than enough free disk space on the filesystem that ...
0
votes
1answer
17 views

SQL Server 2017 - Extracting source and target column names within a string containing column mappings

I have the following format string stored in text (could be any number of columns): col1_source|col1_target;col2_source|col2_target;col3_source|col3_target;... I'm trying to come up with an ...
0
votes
2answers
23 views

Where does Postgres store all statistics?

I recently ran into a weird problem while migrating from PG 9.4 => 11 I replicated the production server from PG 9.4 to PG 11 using pglogical. Everything worked out well, except we discovered that a ...
1
vote
1answer
24 views

Is EXPDP the best backup approach when running Oracle on Windows with no RMAN?

Well, I'm the SQL Server DBA here, and we have a Oracle Senior Dba that manages Oracle Databases and users. I'm curious about how he is handling these servers/users. What is the best approach, when ...
0
votes
1answer
30 views

MSSQL 2008 Database Compatibility Level to MSSQL 2016

I have this database with hundreds of stored procedure, views, triggers, function, ... The database Compatibility Level is 2008 (100) and we would like to move it to 2016 (130). The Sql Server version ...
-3
votes
0answers
41 views

Monitor Disk Space utilization [on hold]

I need a help on capturing the drive space information. I want to know what process used the disk space and what happened to my space for particular timestamp.
0
votes
0answers
2 views

MongoDB, sharding with multi DB instance

I've a MongoDB instance with 40 DBs with same collections, every DB has a name like AWS1010, AWS1011 and so on. Now I've to activate sharding and I'd like to know if it is possible with that situation ...
1
vote
1answer
23 views

Group By with inner join

I am new to SQL world. I am practising on postgresql pgguide sample database . I wanted to count all the purchases of users who have bought a product 'Williams Selden'. So i write something like ...
0
votes
0answers
5 views

Query Quill-Delta JSON array in Postgres

I need to store text in Quill-Delta format, which is in the form of a JSON array, e.g. ----------------------------------------------------------------- | id | title | content ...
0
votes
1answer
17 views

Conditional insert vs UNIQUE constraint

https://stackoverflow.com/questions/4069718/postgres-insert-if-does-not-exist-already I would like to check if something exists before inserting it, what should I rely on? UNIQUE constraint or ...
0
votes
0answers
22 views

Number of rows between two hours regardless of date

I want to get all records between two consecutive hours. But I want to show all rows regardless of day, month or year. I have an approximation but it doesn't works when the range of hours cross to ...
0
votes
0answers
14 views

MySQL InnoDb crash when importing tablespace from remote machine

InnoDB crashes when importing ibd file from remote machine. Source version is MySQL-5.6.40, Destination version is MySQL-5.6.40. Database was backed up was backed Percona Xtrabackup with xbstream ...
2
votes
1answer
23 views

Compute Leap Seconds

I use PostgreSQL 11 and have two columns. One is unix timestamp which is not aware of leap seconds and an utc timestamp which is aware of leap seconds. Is there a way either to find the number of ...
0
votes
0answers
9 views

What is the optimal pipeline for updating table on FK value in Postgresql?

Hi I have the following schema in my app. -- Table: Investment_round CREATE TABLE Investment_round ( id serial NOT NULL, round_type varchar(50) NOT NULL, money bigint NOT NULL, ...
0
votes
0answers
37 views

How to check when a record is replicated in SQL Server

I have configured a database installed On-Premise to replicate certain tables on a Cloud SQL Server database hosted on Azure. The replication task is scheduled to run at specific time everyday and I ...
1
vote
1answer
24 views

Postgresql Deadlock - what does “while rechecking updated tuple” mean?

Question: Can someone please decipher while rechecking updated tuple for me? ERROR: deadlock detected DETAIL: Process 31391 waits for ShareLock on transaction 770573675; blocked by process 25788....
0
votes
0answers
4 views

Uninstall pgaudit?

I have installed pgaudit for my RDS instance in AWS following the instructions here. Now Im not satisfied and move the audit to the application layer and want to uninstall pgaudit. How can I do this? ...

15 30 50 per page