View Full Version : db2 answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 [12] 13 14 15 16 17 18 19 20 21 22
  1. Merge problem
  2. IOWAIT/LOCK state when performing Insert into XYZ Select * from XYZ
  3. Guidelines for db server on SAN
  4. runstats within open transaction
  5. Urgent - DB2LOAD API db2LoadInfoIn Struct
  6. working with a stored procedure
  7. Privileges
  8. listener on port 8888 goes down
  9. Can't get primarykey list using ado openschema
  10. Creating Scalar UDF
  11. Connect to IBM DB2 database without installing the DB2 client.
  12. Multiple DB2 Client Versions
  13. Multiple Application Group possible ?
  14. DB2 - OleDb - Unable to use Catalog Library List
  15. list applications only show one connection (catalog/uncatalog database)
  16. Can you tell if a REORG is in 'paused' state?
  17. getting comm errors in db2diag.log instead of sql errors
  18. Can you tell if a REORG is in 'paused' state?
  19. DB2LOAD API
  20. which data type to select
  21. DB2-Mystery with Multithreading and new compiler
  22. adding constraints to a view?
  23. Version 9 and .NET
  24. restore tablespace backup onto another system
  25. Storing some Japanese data.
  26. Traversing Relationship Tree
  27. db2 jdbc
  28. Cascading delete
  29. cursor as OUT parameter of a stored procedure
  30. cursor as OUT parameter of a stored procedure
  31. Path where database is created
  32. Error while connecting to a database
  33. SQL explain plan
  34. DB2 Development Center & COBOL for Z/OS
  35. String matching in LIKE predicate...
  36. Difference between DB2 Client and DB2 Connect
  37. DB2 Backup strange Problem
  38. Calculating percentage in sql db2 with decmial precision
  39. crash when trying to get snapshot size
  40. JDBC error
  41. DB2 Instance Crash
  42. Finding the 'Client login ID' aka 'Execution ID': DB2 AIX
  43. trigger happy
  44. db2 database online copy help?
  45. DB2 Trigger To Track Table Changes
  46. INSERT but ignore duplicates
  47. Sample table structure to store pics in DB2
  48. Thema: DB2 + XML-Funktionen
  49. SQL7962 Error When Selecting From AS400 DB2 Database
  50. Formatting a Timestamp
  51. How to upload a sql file as a member of a data set in db2
  52. How to upload a sql file as a member of a data set in db2
  53. user authentication
  54. Java / JDBC DB2 export
  55. DB2cca problems.
  56. software services
  57. EMC and DB2 on Z/OS
  58. Raw I/O on Linux
  59. DB2 Client run time for linux
  60. DB2 via REXX on Z/OS
  61. DB2 via REXX on Z/OS
  62. how to do DB2 RTCL upgrade on Linux
  63. SQL Tools for AS400/DB2?? What are you using?
  64. SET CURRENT LOCK TIMEOUT has no effect
  65. Regarding install_jar functioning
  66. Convert rows to column
  67. Convert rows to column
  68. GSS security plugin issues
  69. db2 connect required for accessing db2 on z/os?
  70. BEGIN ATOMIC, COMMAND CENTRE SCRIPT
  71. db2 connect required for accessing db2 on z/os?
  72. Naming conventions for datamart columns
  73. MQT
  74. SQLCODE -204 using a jdbc-driver to UDB DB2 v8.2
  75. Regarding install_jar ... Urgent
  76. SYSPROC.DB2LOAD
  77. SQL2038N A database system error "-5130" occurred during processing.
  78. Load Utility
  79. db2advis with stored procedures
  80. Error while running cron job with DB2 in RedhatLinux
  81. Moving tables to new schema
  82. DB2 Content Manager: Is it J2EE Compliant?
  83. DB2 DAILY CHECK LISTS SCRIPT
  84. Query Tools
  85. Utilizing db2mtrk..
  86. Trranslating ORACLE functions to DB2
  87. Help! inserting records and functions
  88. db2 connection error while running script
  89. CSV file with Headers
  90. How to do a sql update based on a join?
  91. Priming the Package Cache ?
  92. Slow stored procedure after upgrade to 8.2
  93. SQL error
  94. How to join those 2 char columns?
  95. Performance of load from a cursor .... federated cursor?
  96. DB2CODEPAGE Variable
  97. Moving cursor in Command Editor results screen results in update of table
  98. Data Conversion in DB2
  99. Parsing arrays parameters in DB2
  100. Multiple Instances and their corresponding entries in the services file
  101. calculation percentages using sql command
  102. DateFirst in SQL Server
  103. very interesting - why two equal calls is different?
  104. changed machine name - unable to work in DB2
  105. Mother Celko's Monday SQL Puzzle #3
  106. createin privilege
  107. Bad magic number for shared library: libdb2.so
  108. Bad magic number for shared library: libdb2.so
  109. db2pd -activestatements
  110. UnsatisfiedLinkError in Java UDF
  111. Datatype for creating a range value in db2
  112. -2 option in SQL table function for snapshot does not get global snapshot
  113. About Encrypted Data In DB2 UDB
  114. staring and stoping a database in DB2
  115. Can the notification log (.nfy) be deleted?
  116. Inserting Data using a Stored Procedure
  117. SQL1247
  118. SUM(double_value) is not deterministic?
  119. Query Tuning Help
  120. Index creation status
  121. DB2 Instance Crashing
  122. running utility task on all tables
  123. DB2 v8.1 (UNIX) on tape
  124. Performance problem in db2
  125. Third pary tool for db2 backup and recovery
  126. Using a cursor for Update
  127. Tempspace UDB V8 FP 10
  128. Tempspace UDB V8 FP 10
  129. How do we execute this command through java?
  130. Geographical clustering for DB2
  131. Searching for strings and replacing them
  132. multiple result sets
  133. Create DB2 USERS and Connect
  134. DB2 Instance Status
  135. Execution plans and temporary tables
  136. monitor lockwait
  137. Accessing the data from DB2 servers using C# Application
  138. DotNetNuke help Needed!
  139. FOR READ ONLY cursor a named statement
  140. DB2 performance variables
  141. import utility
  142. how to analyze db2expln results
  143. Obtaining parameter MAX_CONNECTIONS through the API
  144. DB2 Access Slow With MISys Application
  145. multiple outer join
  146. Server Security Plugin Error
  147. Cloudscape - usage of?
  148. DB2 Daily Check Lists
  149. Comments in SELECT via PHP/ODBC DB2 UDB v8.1.9 Linux, PHP 4.4.0
  150. Stored procedure slower than an ad-hoc query ?!
  151. Utilization Statistics during data load
  152. Tool to determine Hardware needs for a DB2 server
  153. Creating and using a Cursor
  154. Passing parms to a C Stored Proc
  155. Deadlocks even with SELECT FOR UPDATE
  156. An error on search table.
  157. TIps on Delete Cascade performance
  158. Table definition for Storing a PDF page
  159. Call for speakers: IBM Information On Demand 2006
  160. Error on adding DISTINCT to a SELECT DB2 UDB v8.1.9 Linux
  161. Sort memory
  162. Sort memory
  163. Errors in stored procedure in db2
  164. Problems with performing db2updv8 on database in db2
  165. automated-access-plan comparisons on LUW (db2 v8.2.2)
  166. SET integrity fails despite of for exception...
  167. DB2CMD in XP - DOS batch file
  168. Overflows in tablesnapshot
  169. SQL0954C -- Not enough storage is available in the application heap to process the statement.
  170. Creating a simple UDF
  171. set variables to be used in creation of result set.
  172. DB2 forum???
  173. Slow execution of Delete Statements
  174. Controlbreak flag in result?
  175. DB2 UDB Stored Procedure help
  176. creating pivot tables
  177. Index Naming Standards
  178. optimize DB2 query
  179. database backup -linux to windows
  180. Retrieving most current entry?
  181. EEE - Nodes utilization question
  182. Two tempspaces on database
  183. PLZ help me out
  184. Perl and DB2
  185. DB2 Queries
  186. Installation mess
  187. Create a table with a structured UDT (user-defined type) as a column
  188. Tasks not found in version 8.2
  189. can i use load terminate with cursor for select * from table name?
  190. Passed DB2 UDB 701 test, how can I prepare for 704 test (Advanced DBA)?
  191. Problem with DBD::DB2 and UTF8.
  192. FYI: FP11 and error -925
  193. Running multiple SQL scripts in the background ... no longer possible?
  194. column "generated always as" generated from multiple columns
  195. How to locate the static SQL fired by an application in DB2
  196. The HighValues plague returns....
  197. problem with procedure call
  198. View DB2 Table definitions in QMF
  199. backup question
  200. partioned table or partioned index
  201. DB2 Experts To Contribute To 85K Newsletter
  202. identity-alteration RESTART option
  203. DB2 version 8 DBA (Houston, TX.)
  204. DB2 Connect returning data in HEX?
  205. SQL Cross join
  206. Language Issues
  207. redistribute nodegroup
  208. Rename a database?
  209. Install IBM DB2 on Fedora Core 5 (Bordeaux)
  210. Sudden excessive access time to DB2 via ODBC?
  211. Accessing DB2 on an AIX server via ODBC from MS Excel
  212. SQL stmt to find if table is in load pending state?
  213. IGNORE NULLS possible fro CREATE INDEX? DB2 UDB v8.1.9 Linux
  214. Syntax question DB2 UDB v8.1.9 Linux
  215. Storing Japanese characters in UTF-8 database
  216. Naming ...
  217. Naming ...
  218. GENERAL SQL Question
  219. Help performace question DB2 UDB v 8.1.9 Linux
  220. Truncate Table
  221. column functions
  222. How to recover db2 instance user's privilege?
  223. remove spaces from field contents in DB2 database...
  224. DB2 Backup
  225. Privileges on SP??
  226. I need help
  227. HADR and failed tablespace creation
  228. Multiple SQL SPs accessed from one SP
  229. how to create a DB2 system dsn in linux fedora core 4
  230. Writing file from procedure
  231. Replication using asnload
  232. can someone help me figure out what caused the rollback?
  233. DB2e_Shadow
  234. DB2 Version 8 - libeay32.dll problem
  235. SQL0298N Bad container path Error
  236. Log Full
  237. Duplicate rows from a SELECT DISTINCT DB2 UDB v8.1.9 Linux
  238. Open LDAP Plug-In Anyone?
  239. Multiple Temp Tablespaces
  240. z/OS to AIX connection - authentication/authorization
  241. Viper and VisualBasic
  242. Calling SYSPROC.DB2LOAD within SQL stored procedure
  243. Moving db2 to a dedicated partion
  244. Should db2 summarize or home grow a build app in C
  245. problem with long object name
  246. FETCH FIRST ROW ONLY
  247. plz help me out
  248. delete from table where in, problem
  249. top-down-top query approach
  250. MERGE in V8.2 FP4 (on condition returns multiple rows from target)
  251. Differences between UDB V7.2 and V8.2 for federated connections?
  252. Uninstalling v7.1 on Solaris
  253. re-configuring db2 server for client operation? [comparison to oracle]
  254. Compiling stored UDFs
  255. Parameter Markers in SQL queries and ADO.NET
  256. Lock escalation in SYSCOLDIST
  257. help me out
  258. How do I do this in DB2
  259. DB2 Viper Testdrive
  260. SQL0902C - SQLSTATE=58005 - Reason Code = "14"
  261. Seek newbee Java UDF installation tip
  262. Blocking Agent ID for Locks in SNAPSHOT_*
  263. Multiple temp tablespaces with same page size
  264. Multiple temp tablespaces with same page size
  265. ADO.NET - strange behavior
  266. About automatic database maintenance
  267. db2pfchr processes and high CPU
  268. Catalog Database
  269. Problem with Global Temporary Table
  270. About Multiple Cursor from Stored Procedure
  271. db2cmd.....
  272. SQL issue? Can this be done?
  273. Reading an explain Plan
  274. Functionally equivalent exception Join
  275. Command Editor problem?
  276. Extended optimization messages
  277. Is "One view per table in DW" really a good practice?
  278. locks and related
  279. Confused on how to get a percentage of total using OLAP functions
  280. slow download-insconsistent latency
  281. DB2NTMEMSIZE
  282. db2diag.log error
  283. Need ROLLUP expert advice!
  284. Is there a way to find the record causing SET INTEGRITY command to fail?
  285. Problem inserting spanish characters in DB2 UDB
  286. Problem with Backup/Restore with Vendore Products
  287. How to Drop data from table quickly
  288. db2_evaluncommitted
  289. Parameter.Add need help - not understanding
  290. DB2_FMP_COMM_HEAPSZ - need help!
  291. Sequences in db2 8.1.0.36.
  292. Grouping SQL statements
  293. SQL6024E Table or index "tab_name" is not defined on node "0".
  294. SQL Server co-existance
  295. how to rollforward without userexit - SQL1268N
  296. db2 File system caching ..DIO or CIO??
  297. db2 File system caching ..DIO or CIO??
  298. db2 File system caching ..
  299. Control Center Error
  300. Alter Column
  301. Illegal Immigration, the Non-Issue of the Week??????????????
  302. How to obtain the schema from a JDBC Connection ?
  303. 2-nd edition of Celko Puzzle book in the works
  304. Truss output - semget analysis
  305. Inserting data into a DBCLOB column
  306. Passing a parameter to IN predicate of DB2 udf
  307. LOWER() and UPPER() functions not found.
  308. limiting number of rows returned by resultset
  309. Control Center doesn't find backup files
  310. Issues with loading 124 million records
  311. Set level acestor report; DB2 UDB 8.1.9 Linux
  312. Restore not finished
  313. Query performance
  314. jdbc and list of all databases
  315. Is db2uext2 archiving directly to tape?
  316. DB2 Application Development Client
  317. creating a database using DB2
  318. Mixed Case in table and column names.
  319. T-SQL to DB2 UDB SQL-PL conversion...
  320. SQL construct conversion...
  321. Can't get table out of check pending state after load.
  322. Group Authentication
  323. DB2 V8 z/OS
  324. What's wrong: SQLCODE -30082 password missing (on windows)
  325. SQLCODE -1024
  326. Computing the product of a column groupped by...
  327. Triggers crashing database ?
  328. Migrate DB2
  329. SQL1224N - A database agent could not be started to service a request
  330. jpg file to mainframe
  331. Mixing SQL and traditional I-O in an ILE COBOL program
  332. Query Performance
  333. DB2 Control Center crashes
  334. insert data into graphic column
  335. Shell Script eroor while using db2 export
  336. Locking issue
  337. regd data migration from DB2 v7.2 to SQL server 2000
  338. i can not create db2 sample
  339. Transaction Log full.
  340. # of Agents -> db2 list applications
  341. Tablespace on NFS (Netapp filers)
  342. deadlock related
  343. [IBM][JDBC Driver] CLI0622E Error accessing JDBC administration service extensions.
  344. Authorization/Privilege Issue
  345. SQL/PL Stored Procedures and SYSIBM.SYSDUMMY1
  346. Case Sensitivity in DB2 on linux
  347. alter query
  348. DB2 Query problem
  349. DB2 UDB Detective - Ace Ventura
  350. NULLID.SYSSN300
  351. Logging
  352. odbc connect string and library list
  353. SQL help
  354. Is LOAD really this brain damaged?
  355. Sequence number for a Batch
  356. Help me to Create Database
  357. DB2 Redirected Restore
  358. About Encryption Function in Db2
  359. iSeries: JDBC problem v5r3
  360. multi-file multi-table import
  361. table identifier for db2ReadLog
  362. Simple Query
  363. to fetch first record
  364. DB2 exception handling in triggers
  365. DB2 error handling in triggers
  366. How to get generated key back in php/db2 v8.1.9 Linux
  367. How to do more things in DB2
  368. Is this the right way to go about ranking things?
  369. Backup a suspended database with SMS tablespaces possible
  370. nonrecoverable load during backup
  371. User Defined Function in DB2 Urgent Help please
  372. Exporting current system timestamp to unix server
  373. Timestamp equivalent in DB2
  374. SQL0818N after V7 -> V8 migration.
  375. IXF LOADing w/ different column orders
  376. Sql help
  377. DB2 SQL error: SQLCODE: -805, NULLID.SYSLH20A 0X5359534C564C3031
  378. DB2 CF and Visual Studio 2005
  379. How to load a cursor from a stored procedure in DB2
  380. Strange error:An unexpected token ")" was found...Expected tokens may include: ")"
  381. 2 version of admin client on same PC?
  382. about high security field
  383. DB2 Incremental BackUP / Restore problem from one machine to another
  384. Checksum for Duplicacy check
  385. Catalog-view to get tablespace-state?
  386. Places to schedule database backup in DB2 UDB V7
  387. Cursor Load fails with SQL0964C error
  388. Merge Alternative
  389. Upgrade my db2 8.1 fixpak 6 to last release
  390. V8.2 Express Edition XP Home
  391. task center error 22207
  392. size of db2 udb database
  393. Ink
  394. Just for laughs..
  395. Migrating DB2 UDB 8.2 dbs from windows platform to Linux
  396. Building Simple SQL Stored Procedure
  397. Ink
  398. HELP! reading syscat from php in db2 udb v8.1.9 Linux
  399. Recover IBM DB2 Data (Urgent)
  400. Senior Mainframe Cobol CICS DB2 Programmer Needed in Alabama
  401. Stored Proc Performance Improvement
  402. Stored Procedures / UDF
  403. DB2 program to read log files ... incorrect function identifier
  404. Data Replication DB2 VM to UDB with DPROP
  405. Data Replication DB2 VM to UDB with DPROP
  406. DB2 Backup into 3590 tape drives
  407. Difference between Collection ID and qualifier
  408. problem with Group By
  409. Comparing dollar amounts stored in a varchar
  410. Adding user data to the system metadata tables Db2 UDB v8.1.9 Linux
  411. DB2 and embedded SQL
  412. Expected Impact of Changing Logging Type
  413. get a list of all users in db2
  414. Query performance - Please help
  415. extracting db2 table records to csv
  416. How can i connect to tables created in a schema with a username different from the schema name?
  417. Drop Table
  418. Optimizer not using MQT ?
  419. load data into varchar column
  420. Relocate DB2 databases part 2
  421. How to convert DB2 data type P to SQL
  422. What is the connected database?
  423. How do i ensure 'insensitive' (ie static) cursors that are only forward readable (in DB2 for mainframe)??
  424. Select the 2nd of a sequence of rows in a table
  425. SQL to get the max or min record which one is better?!
  426. What's incorrect with this function?
  427. Relocate DB2 databases
  428. DB2 Rollforward DB query status
  429. DB2 + shell script
  430. Is there a way to import tab delimited files into a db2 table?
  431. DB2 Table Editor Search Conditions
  432. load from cursor
  433. load from cursor
  434. UNIX shell script and DB2 Queries
  435. Sort after index scan
  436. OS/2 (yes) backup to XP Excel
  437. Inserting into temp table using Cursor
  438. Changing an index controlled partitioned table to table controlled.
  439. Alert notification time
  440. MDC + Partitioning Key
  441. SQL Query to concatenate columns
  442. Statement Isolation Level
  443. Concatenating rows ?
  444. generated columns for z/os
  445. Uregent finding difference between count of two coulumns
  446. How to get instance's server port?
  447. Selecting only letter and number characters
  448. SQL1031N error help
  449. UDB sort sequence problem
  450. report issue
  451. How do I prune db2rhist.bak and db2rhist.asc?
  452. Generating SQL Scripts from SPUFI
  453. How to find out the Java Version in DB2 personal edition 8
  454. select count(*) - Full table scan
  455. Convert DECIMAL to DATE
  456. Restore to new node using TSM fails
  457. Error while running sdl scripts
  458. Parallel Database
  459. WPAI on iSeries DB - Problem
  460. CLI Wrapper for .NET Platform
  461. DB2 UDB Error Handling
  462. Bulk Load BLOB using DB2 CLI
  463. Easy Group By Question (I think/hope)
  464. Puzzled
  465. How to do...well...anything...in DB2 SQL
  466. DB2 - Decode Compiled SQL Statements
  467. Exception Handling in DB2 UDB
  468. Exception Handling in DB2 UDB
  469. Restore into DB2 replication database
  470. Isolation Level inside C++ routines / Slow performance.
  471. Database metrics
  472. DB2_LARGE_PAGE_MEM
  473. db2exfmt - client
  474. Product license ? Run time client ?
  475. Preserving comments when creating SP's from Command Editor
  476. Comments in Selects DB2 v8,1.9 UDB Lunix
  477. Lookig for a copy of "The ABCs of Plans and Packages" by Nicola Nur
  478. Trouble connecting to DB2 in Visual Studio 2003
  479. DBA cert
  480. Urgett !! redirected restore of a tablespace
  481. How to kill idle connections or sessions
  482. Max Connections
  483. Packages, Bind, Prepare and Execute
  484. Max Connections
  485. How to get my current connection id in SQL
  486. benefits of 64-bit db2 apart from addressability
  487. creating a Report
  488. have some fun and forget the problems
  489. CLP Execution
  490. db2 and the strip function
  491. DB2/COBOL Store Procedure Parmeter List (Reply)
  492. CPU Time (User / System) & Actual Elapsed Time for SQL
  493. DB2 8.2 32bit to 64 bit conversion
  494. Running a batch of sql queries?
  495. Running a batch of sql queries?
  496. DB2/COBOL Stored Procedure Parameter list
  497. Multiplatforms?
  498. Could you clarify IY63894 ?
  499. More than one CURRENT TIMESTAMP in a PROCEDURE
  500. Is it possible to move the ICMNLSDB database from one drive to another?
  501. how ADM1822W could happen?
  502. DB2 RT Client silent install
  503. refresh view ?
  504. federation
  505. Import Problem Urgent
  506. JDBC Type 4 Universal Driver SQL Error Code = -99999
  507. Data Warehouse Cube View Control Center
  508. Package cache hit ratio
  509. DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
  510. DB2 Connect Ver. 7.2 Client Assistant Export problem in Windows 2000
  511. delete statement after a RETURN CURSOR in SP ?
  512. Convert TimeStamp
  513. give me idea for this problem
  514. give me idea for this procedure
  515. Federated database and host privileges on SYSIBM tables
  516. Query regarding Index
  517. Debugging SQL stored procedure using developement center
  518. Debugging SQL stored procedure using developement center
  519. DB design
  520. DB2 Sample Test Question? Which is the correct answer?
  521. Basic SQL prcoedure question
  522. Problem using db2sql92 on host db2 (Langlevel or missing package)
  523. DB2 Altering an integer to character type
  524. How to connect to the DB2 on a REMOTE machine from a C++ application on Linux?
  525. Connectting to as400 from DB2 ESE running on Windows XP
  526. Online Tablespace restore from incremental backups
  527. SQL0901N Error.
  528. Export af Tasks from Task Center
  529. DB2 ESE add Partition fail
  530. estimated execution plan
  531. FW: SR 603066805 : FW - Firewall in transparent mode with excessive packet drops
  532. Hast Du das schon gewußt?
  533. Special considerations to backup using ntbackup
  534. Report formating
  535. websphere vs sharepoint
  536. Aggregating strings
  537. Test database connection using C++
  538. memeory usage
  539. Licensing Issue
  540. my db2 routine deleting records with commit count ,any advice ?
  541. DB2 Replication Centre Issue
  542. online monitoring of sql statements
  543. Cannot Execute Create Server
  544. modelling tool
  545. Strange Errors in db2diag.log
  546. DB2 Certification exam 700 and 701 Question papers
  547. UDB: Backup Image Size & Used Pages Size
  548. problem with ibm db2 8.1 fixpak11
  549. urgent - Formating issue
  550. "SQL1024N A database connection does not exist" when using db2GetSnapshotSizeData and db2gGetSnapshot