The load tag has no wiki summary.
1
vote
0answers
22 views
DB2 Load Failure due to timestampformat
I'm trying to load a file into DB2 database table using DB2 Load. I'm able to load the file, using the following statement from the unix prompt.
db2 +p -x load from BOM_Sales_20130326.txt of DEL ...
0
votes
2answers
77 views
High Mysql Load , over 700% CPU
I had high mysql load on server linux 64 bit , 24 G.B ram , Intel(R) Core(TM) i7 CPU 950 @ 3.07GHz ,
Alot of quiers in sending data mode
Here is mysql status
...
0
votes
1answer
57 views
Integer comparison in MySQL. does it cause lots of overhead?
I have an 8 digit number in my db. I want to do a select on the table in MySql (Innodb) and get the list of all numbers that are equal or smaller than my number. Then I sort them from larger to ...
1
vote
1answer
110 views
Is SET INTEGRITY of any use after IMPORT statements, or just after LOAD statements?
I'm getting the feeling, both from documentation and empirically, that you can only put SET INTEGRITY to good use after a LOAD, not after an IMPORT. LOAD is mentioned for SET INTEGRITY, but not ...
3
votes
1answer
150 views
Named pipes connection closed when subjected to load
We're hosting a service where we have a messaging service. When a message arrives, it checks which subscribers it should be sent to by connecting to the database, and querying the subscriptions ...
2
votes
1answer
214 views
Do database servers need load balancing?
I am trying to build a 1TB database on MySQL which will need strong read performance. I intend to replicate my database to prevent downtime.
Do my database servers need load balancing to improve ...
2
votes
2answers
140 views
How do I import a specific line from a text file into MySQL
I'm building an app to import data from a text file to a database.
I want to import only specific lines from the text file. With Navicat I found that we could limit number of line when importing ...
2
votes
1answer
704 views
DB2 LOAD data into table - Interpreting the error messages
I encountered some constraint issues when loading data from file into table
**
SQL3109N The utility is beginning to load data from file
"xag".
SQL3500W The utility is beginning the "LOAD" phase at ...
