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. how to use COALESCE?
  2. DW Specialist
  3. Cursors
  4. Data change table references and SQLCODE -20165
  5. How to compare several rows in one table???
  6. space utiilization in a DMS tablespace
  7. Error While installing DB2 on RHEL5
  8. DB2 & Oracle source code reusability
  9. Db2Viper2beta on Windows Server 2k8beta3?
  10. Can stored procedure have call to subroutines
  11. join with example
  12. fetch cursor
  13. Stored procedures and Global temporary tables
  14. DB2 DBA 702 Certification exam
  15. DB2 Logging in Materialised queries
  16. db2 with cd
  17. Insert into AS400 table locks bacuase of trigger
  18. prevval and nextval for a sequence
  19. Deadlock/timeout error
  20. Stored Procedures Updates
  21. Restoring, can't redirect tablespaces
  22. Sort Performance
  23. Able to alter or drop a table but cannot create the table, when no permissions are given to that user
  24. SSIS and DB2 Schemas
  25. IMPORT with METHOD N
  26. how to import db2move.lst
  27. size of the database ?
  28. DB2mscs command
  29. Granting DML privileges on all the tables of a schema to a user
  30. Runstats Utility
  31. Short circuit boolean eval in trigger WHEN clause?
  32. Sqlcode +97
  33. SQL need to be optimized
  34. Delete/update Sql/400 Stored Procedure Not Working
  35. History query question
  36. Basic Cron job not working in UBUNTU
  37. faster CPU vs more RAM
  38. waiting on archive
  39. Create Table sql0204 error
  40. SQLPRIMARYKEYS corrupted
  41. IBMDEFAULTBP setting
  42. "I" is not valid in the context it is used - db2 command line sql
  43. db2updv8 necessary for FP14 -> FP15?
  44. oad done on a table with nonrecoverable option on a archive loging enabled Database
  45. Main differences between DB2 v7 & v8 in a Z/OS env
  46. Writing a stored procedure in command editor
  47. Write a cobol program without using session table
  48. Improving Performance in DB2
  49. DB2 Not ATOMIC Compund SQLs
  50. Fixpak installation in db2 udb
  51. Syntax to Update Timestamp Column
  52. How to run db2commands in windows cmd prompt
  53. Reason for DB2 error code Sql0204n
  54. How do you get load to reject and not truncate data
  55. DB2 error SQL30081N on AIX version 5.2 / 5.3
  56. dropped a not null column from a table, error while running stats
  57. dropped a not null column, having problem in Update
  58. Definition of empty table
  59. DB2 Installation Problem
  60. Executing DB2 commands from Windows command prompt
  61. The database alias "MONITOR" already exists Can't Not Drop it
  62. Invalid cfg for DAS tools catalog (or maybe db2fm)?
  63. Sorting data within inline queries
  64. Hang on archive
  65. XSU Java package with DB2
  66. Tracking DML changes for important tables
  67. writing output of Stored Procedure to an outputfile
  68. Restore backup performed on Unix server to a Windows server
  69. some arbitrary application ids in "db2 list applications"
  70. tracking DML on important tables
  71. Automatically disconnecting DB2 clients which are inactive for some time
  72. Efficiency of DB2 LOAD RESUME vs REPLACE
  73. fortran db2 on Windows
  74. OracleXMLQuery class with DB2
  75. Unresolved external with DB2 v9
  76. Informix current sessions with database names
  77. ORDER BY CASE Problem
  78. db2 CASE statement in ORDER BY clause
  79. ODBC connection to V7 and V8 databases simultaneously
  80. Verify File before import
  81. Java scalar function slow
  82. .Net Framework Data Provider for DB2?
  83. Table Functions using Db2 on Z/Os
  84. INSERT binary data
  85. Insert using RRN?
  86. DB2 as web service client?
  87. Interface tools for DB2
  88. SQL1032N No start database manager command was issued. SQLSTATE=57019
  89. TSA binary for Windows
  90. That works faster in DB2 for creation of an index?
  91. Adding a not null column to a table with 0 rows
  92. db2_deinstall command
  93. How to use DB2 ODBC on z/os with COBOL
  94. Error comes when insert records
  95. SQL0440N No authorized routine named "||" of type "FUNCTION" having compatible arguments was found.
  96. Mainframe file loaded into DB2 table
  97. Use of SELECT [Fields] INTO [var] in UDFs
  98. How to find out last REORG timestamp ?
  99. HADR primary to standby
  100. ADM1844I - Many Many Warnings in the event viewer... Why ?
  101. DB2 privileges, Direct and Indirect SYSADM
  102. How to Handle IF THEN ELSE IN DB2
  103. Effects of Increasing the locklist parameter
  104. Problem with accessing 2 different tables using the same binary
  105. Combine queries for single output
  106. Another Bizzare Crash...But no Recovery. SOS!!
  107. SQL Server 2000 linked server to Db2 on z/OS
  108. DB2 Merge performance
  109. informix/db2
  110. DB2 function
  111. How to write query with two select statements in db2
  112. SQL or stored proc
  113. rid
  114. Odd Diag Log Message on V9 FP2
  115. load/import in db2
  116. how to change user password
  117. query runtime problems - same tables joined together
  118. How to IMPORT MS EXCEL worksheet in Kanji (Japanese) to db2/400
  119. maximum number of column can be set as Primary key in DB@ V8
  120. updating the locklist
  121. How to get the zero's for unsatisfied fields in group by clause in DB2
  122. Need to connect to Db2server
  123. converting Oracle PL/SQL function to DB2 v9
  124. Sqlstate 42972 from Query
  125. stored procedures perf. question
  126. Data load in DB2
  127. db2 exam 701 dumps
  128. Return columns using db2_columns() via PHP
  129. print value during execution stored procedure
  130. Query question
  131. Indexing of table in DB2
  132. setting user name password and user name for automating create script
  133. High water mark
  134. declared global temp table with merge
  135. The Question about REDIRECT RESTORE
  136. sql error -530
  137. When should we Reorg
  138. Background Process for Reorgcheck
  139. Background Process For Backup
  140. db2 on raid5, striped disks, SAN
  141. Alter column precision
  142. Select null as xyz from sysibm.sysdummy1
  143. fastest way to delete 1 billion rows from a table haveing 9 billion records
  144. Select null as xyz from sysibm.sysdummy1
  145. Generated Column
  146. Poll: DB2 V9.1 Adoption
  147. Count the transactions happened in a database
  148. Describe Sql View
  149. Select From Db2 W/php Error
  150. Not a trial, a commercial tool you can use for no charge for as many databases as you want
  151. Backup Information
  152. compare the tables between TEST and DEV
  153. DB2 Control Center not responding
  154. Is there any attribute which indicate the last access date?
  155. How to determine the DB2 version
  156. Querying "Sequence" in Select statement
  157. Got a intresting problem
  158. Backup Information
  159. Conversion of Oracle 9i to DB2 V9
  160. Software Testing Tools
  161. Sybase to DB2 Data Movement
  162. expanding a default value
  163. DB2 V8 (mainframe) Install - 'Resource Not Available' Msg
  164. how to replicate the SQL Server 2005 Procedure to DB2?
  165. DB2 execute permissions issue
  166. Disabling the DB2DETAILDEADLOCK event monitor
  167. Problem in Automatically generated columns while copying schema
  168. "channel DB2"
  169. When is an offline backup not really offline?
  170. Incorrect results using FULL OUTER JOIN in DB2 v8
  171. DB2 Two "how to" questions - [conditional loading and variable use]
  172. DB2 Automated Backup configuration parameters (DB2 UDB v8)
  173. package name restrictions
  174. Selecting Field Description With DB2 and SQL
  175. Archiving Older Data
  176. SQL0206N "BLOB" error
  177. DB2 on AIX throw exception with SQL that has (
  178. DB2 V8.2 - Value compression question
  179. problem with POSSTR
  180. Error while declaring a global temporary table
  181. INSERT IGNORE in db2
  182. J2EE Professionals for Bahrain
  183. Reading Tables & Columns
  184. db2 restore database
  185. Multi Row Insert using an SP in DB2
  186. exam cost??
  187. using Dynamic SQL for Update
  188. Express-C
  189. DB2 Viper 2 compatibility features
  190. Dump of a schema in DB2 / Admin_Copy_Schema
  191. Database Size Problem
  192. Funny
  193. Help me on Query fine tune.Explain report details provided.
  194. Problem with AutoCommit & problem with XML insert
  195. Db2
  196. setting the termination character in CLP
  197. Nested case in DB2
  198. Nested case
  199. DB2 Z/OS Stored proc help
  200. Db2
  201. setting pause on output in CLP (Db2 9)
  202. How to change a column from a not null to null
  203. Oracle EXPORT and DB2 LOAD
  204. SAP DB2 userids
  205. Perl DBD::DB2 connect error
  206. COM.ibm.db2.jdbc.app.DB2Driver
  207. How to insert and retrive data from Visual Stidio 2005 (MFC) into DB2???
  208. IBM][CLI Driver] SQL1032N No start database manager command was
  209. How to export resultset to CSV
  210. How to export resultset to CSV
  211. How to export resultset to CSV
  212. How to export resultset to CSV
  213. How to export resultset to CSV
  214. if "all applications disconnection" is anathor tigger of page cleaner?
  215. killing application/thread automatically
  216. importing data with CR-LF
  217. Insert values into a table B based on a flag on table A
  218. Sql performance Tuning
  219. Database inconsistant?
  220. Sql-Translation: Oracle to DB2
  221. DB2-quries
  222. lock escalation
  223. Unicode...
  224. Tablespace STUCK in Roll Forward in Progress State...
  225. How to make a generated column function of other columns?
  226. db2 pring command for dynamic queries
  227. Calling a nested stored procedure in DB2
  228. Performance of JOIN vs. singleton SELECTs
  229. How many cursors?
  230. What are the process to add another DB2 database to existing Instance?
  231. connect as400 to mysql
  232. substr of a number's field
  233. Emptying index advisor cache
  234. DotNet compatibility of BLOB datatype
  235. positioned update
  236. Tablespace remains full after deletions
  237. Big problem with DB2 and Clobs...
  238. How can i Connet from 1 DB2 Server/Client to Remote Server on AIX
  239. The Best DB2 Articles
  240. DB2 Automated Backup configuration parameters.
  241. Need help getting DB2 Connect to catalog a remote AS400 DB2 server
  242. Load Data from fixed length/delimited feed file
  243. How to get System Date in DB2 with SQL Statements
  244. I need help to fine tune below query..urgent please.
  245. MIGRATE DATABASE from 7.2 to 8.2
  246. How to find no.of deleted rows
  247. DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501
  248. Examination 070-229 Resource
  249. ERROR SQL in DB2
  250. Restoring the event monitor file
  251. plz help:i want to create db2 account Not using OS account
  252. CREATE PARTITIONED TABLE - SQL0104N error
  253. 5th Fast Track Automation batch from Quality Globe from August 9th.
  254. SELECT of Members
  255. inserted values required with the given format
  256. Compare two databases in different subsystem
  257. Lock Escalation
  258. Troubles inserting to a new unicode table....
  259. clientside backup of partioned database
  260. quiesce database problem
  261. Prevent database user to access another database
  262. Use of REORG TABLE in a C++ Applikation for db2 Version 9
  263. CLOB columns change after database restore
  264. Need to display the header as the top row in the recordset
  265. Laptop Version ?
  266. Db2admin password
  267. check constraint
  268. DB2 load utility and subsytem
  269. DB2 Concepts
  270. DB2 Vers 8.1 installation error on WinXP
  271. DB2 connectivity
  272. TCP/IP Communication Error
  273. mainframe (7.1.1) lock escalation
  274. application id
  275. how to get even or odd number rows from database in db2
  276. [Question] DB2 LUW V8, regarding after drop tablespace behavior
  277. DB2 INSERT search for space
  278. runstats from reorgchk update stat
  279. Outer Joins in MQT`s
  280. migrating SQL Server data to DB2
  281. SQL stored procedure in Z/OS (DB2 ver 7)
  282. how to *really* remove a database in DB2 ..
  283. Insert v/s Load
  284. creatin a trigger
  285. To create a trigger
  286. xml
  287. connection remote to DB2 database with the C/C++, with prohibition of installation DB2 client software.
  288. execution time in HADR
  289. ClientBean and ReportBlox
  290. V8.2 Check if nonrecoverable load was done
  291. sql update to a substring
  292. V9 Column Rename
  293. HADR performance issue
  294. Sqlstate = 56038
  295. db2 replication Center
  296. Error activating a database/cannot allocate agent
  297. DB2 Common gcf error
  298. QMF vs SPUFI
  299. import from NUL converted to ordinary delete
  300. Problems with starting DB2 service on windows
  301. SQLJ default context override
  302. DB2 queries
  303. Migrate Data from Oracle 10g Express to DB2
  304. Order of Where and Composite Key
  305. Stored Procedures for DB2 z/OS Developed with SQL Language
  306. Very basic formatting question
  307. DB2 Container Size Limit
  308. at the start of db2
  309. First process in db2 startup
  310. Errorr execute immediate
  311. displaying a date
  312. Get error SQL0723N when trying to insert a row into mainframe DB2 from web server
  313. Mqt Store Procedure
  314. Newbee Query Problem
  315. IN versus ANY versus EXISTS
  316. DB2 Load utility
  317. describe command
  318. Specifying Record Delimiter
  319. SQL0338N-Error
  320. Delete rows from two tables
  321. db2 sql query
  322. SQLCODE: -805, SQLSTATE: 51002 , this is the error code
  323. Temporary table in DB2
  324. Summing a column as a seperate column in the same query
  325. db2_pconnect SQL10007N Reason code: "3"
  326. Nested selects
  327. Invoking Stored Procedures in Triggers
  328. Oportunidade Stefanini It Solutions
  329. BEFORE OPTION
  330. Max length Locate can handle
  331. MF COBOL/DB2 Error
  332. Clob In Db2 Aix
  333. DB2 "Net Search Extender" for v9.1
  334. Define a return value in store proc.
  335. Creating Function Template in UDB 8.2 with TABLE return type for Federation
  336. SQL Error in DB2 and MS Access
  337. DB2 migration utility ?
  338. Looking for a db2 tool that converts Oracle to Db2 - Migration assistant?
  339. DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
  340. 64bit client application in a 32bit instance
  341. Software Testing Cycle
  342. DB2 Certification Exam question
  343. Packages and Procedures
  344. DB2 online data copy
  345. Db2-cobol Program
  346. Isolation level - interesting scenario
  347. Update difficulty
  348. Interesting isolation level problem
  349. access level problem in multiple instance
  350. db2 offline db restore from v7.2 to v8.2
  351. Version Recovery (Db2 on AIX)
  352. Formatted CURRENT DATE
  353. SQL0104N An unexpected token "DATABASE" was found following "CREATE ".
  354. After merging - how to bring over parent_ids
  355. DB2 database shutdowns after excecution of sqlj procedure
  356. VARCHAR field that is not NULL
  357. DB2 ver 7.1 Processing was cancelled due to an interrupt
  358. Help on Null
  359. LIbrary System
  360. db2 704 exams
  361. Very urgent.. need threshold levels for db2 monitoring metrics
  362. SQL Code -181
  363. 4th Fast Track Automation batch from Quality Globe from July 24th.
  364. iNFO O db2 CERTICATION REQUIRED.
  365. How to reduce the ImageCopy job run time
  366. how to ignore errors when creating stored procedure?
  367. help in DB2 Load command
  368. db2 wsad connectivity
  369. Import SPF via Script
  370. SQL0332N There is no available conversion for the source code page
  371. library system
  372. SQL0206N, case statement and time calculation
  373. Failed to load libaio
  374. Asp - Db2
  375. db2 doubt
  376. Catalog Node : Port Number
  377. HELP! declare global temporary tables?!?
  378. HOW to convert a character type into date format
  379. need a little insight on index that allows reverse scans
  380. select from a sequence and from a table in the same statement
  381. update from a select
  382. Storage quantity
  383. Commit Active problem solved (db2rhist.asc)
  384. STOP RUN in DB2 stored procedure
  385. how do you add a zero to the left of an integer
  386. view tables
  387. Retrieving latest row
  388. Error in DB2 (COBOL/DB2/CICS )
  389. Space instead of Null
  390. plan and package
  391. IBM supplied WLM stored procedures
  392. Client compatibility
  393. Oportunidade Stefanini It Solutions
  394. How does threads work in DB
  395. load vs. import ( warnings )
  396. row_number
  397. LOAD and LOAD with AMDIN_CMD
  398. Replication tutorial
  399. DB2 subsystem
  400. SQLCODE groups
  401. Db2
  402. Is there any command or tool for doing DB2 Catalogs reorg/check?
  403. complile and execute a stored procedure.
  404. Run DB2CMD commands through PowerShell
  405. DB2 versus UDB
  406. Controling tablespace for a primary key index in alter table
  407. Db2 700
  408. Need help on data replication and available options
  409. Rename a tablespace file?
  410. Is there any way to make my transcripts of the DB2 certifications viewable for public ?
  411. How to speed up this SQL statement
  412. How to extract sequences in db2 udb 8.2
  413. log table changes with a trigger...
  414. IBM and AGS Announce Availability of New Solutions for Informix Dynamic Server
  415. Contokens
  416. check pending state
  417. message in db2diag.log
  418. DB2Dart Report meaning
  419. problem during database connection test in db2 stored proc
  420. db2dascln
  421. db2 iseries
  422. Application inventory DB
  423. list of parameters that has to monitored by a DBA in db2 UDB
  424. list of Parameters that has to monitored by a DBA in db2 UDB
  425. Renaming an instance
  426. Could this be DB2 or an Access problem??
  427. How to take the database backup
  428. How to define my own exception in db2 stored procedure
  429. DB2 Trigger Help
  430. update a column on particular table relation with multiple tables
  431. ROW_NUUMBER LOOP
  432. Software Quality Management
  433. Need Help with db2 db2start throwing SQL6048N error
  434. Query help...
  435. DB Backup error
  436. DB2 Driver- ClassNotFoundException-Please help
  437. Oportunidade Stefanini It Solutions
  438. Ibm Db2 Sql
  439. Error in loading data into DB2 table
  440. common problems found in db2
  441. Universe locks
  442. command for viewing DB2 configuration parameters
  443. IBM Establishes Global Center of Excellence for Nuclear Power
  444. Corrupt Trigger Nameless
  445. Stored Procedure
  446. Error uninstalling DB2 V9.1 (XP Home)
  447. DB2 700 Exam
  448. SQLDA corrupted when using VARGRAPHIC type parameters
  449. DB2 Certification
  450. db2ReadLog, Variable format data
  451. How to do DB2 Clustering
  452. db2jstrt or db2jd on OS/390
  453. db2look -tw
  454. What are the Files generated after db2 installation
  455. Cobol precompiler query
  456. Installing and Operating DB2 Within Windows Domain
  457. Tables and Columns security in database db2
  458. Long running of DB2 Queries
  459. Creating Indexes For Declared Temporary Tables
  460. How to execute a procedure in DB2
  461. CMMI Practices
  462. DB2 trigger failing while calling stored procedure
  463. How to change the primary key for already existing table?
  464. Statistics with volatile table
  465. Cannot Load
  466. Third Fast Track Automation batch from Quality Globe from July 5th.
  467. "Best Fit" Match against multiple tables?
  468. PHP5, ibm_db2 connection problem
  469. COBOL DB2 V8 Mainframe - moving data from one table to another
  470. Primary Key
  471. DB2 Model
  472. Primary Key
  473. specified attributes not existing with existing column error on Altering table
  474. Getting error whle changing the Datatype of a column in the table.
  475. When to use cursors?
  476. Migration from V8(solaris) to V9(redhat)
  477. normalizing two related tables
  478. How to specify the creator in db2connect
  479. Left outer join with case
  480. Dates, DB/2 and Java
  481. Query's Strange Behavior
  482. [IBM][CLI Driver][DB2/6000] SQL0952N - HELP
  483. DB2V8.2 DPF CPU Usage
  484. AS400JDBCDriver, encoding charset
  485. Issues when deploying applications on WebSpeher process server.
  486. [IBM][CLI Driver] SQL1284N The attempt to connect to database
  487. Query from more than 2 database
  488. Query from more than 2 database
  489. Please..need SHA1 implemented in DB2 version 8
  490. Need help on deleting log file (log_dir)
  491. UDF's crash after new CPU installation on AIX!
  492. set integrity
  493. The database manager is not able to accept new requests, has terminated all requests
  494. how to declare temp tables in a user-defined function
  495. Non-SOAP Web Service in DB2 9
  496. Event monitor that gives more lock info?
  497. Error Message Retreival in SQL Stored Procedures
  498. Applying CURRENT TIMESTAMP On Updates
  499. Db2
  500. What is the difference between BIND REPLACE and REBIND commands?
  501. Basic doubt in union.
  502. JDBC: Connected but no tables shown
  503. DB2 SQL Query
  504. timestamp
  505. Db2javit:rc=9505
  506. Delete table command in DB2 SQL ?
  507. db2 9 processes on linux.
  508. how to add a logical partition on the same computer.
  509. Replication : when asn.IBMSNAP_UOW is pruned ?
  510. BACKUP PENDING(Help me,Please)
  511. Inoperative packages vs. invalid packages
  512. Self Join in DB2 SQL
  513. Troubles using DB2, Websphere 3.5 and Java
  514. Effect of manually updating AVGCOMPRESSEDROWSIZE?
  515. is this table function possible for IBM DB2 v8.2?
  516. Mapping between Package and DBRM.
  517. JDBC type 4 driver for DB2 v7.1
  518. case and count
  519. SIMPLE but SLOW SELECT query!!!
  520. where do i declare the user temporary tablespace?
  521. temporary global tables
  522. Replication error
  523. functions that returns a table
  524. I cannot find License key
  525. Data Dictionary counterpart in DB2
  526. lock escalation : how "expensive"?
  527. INSERT Trouble
  528. How to create user Temporary table in DB2
  529. Migrate from v7 to v9, 32 to 64 bit
  530. How to Update Blob with JDBC?
  531. Generated Always As Identity
  532. COMPRLIB in backup
  533. Comparison of two rows in a table using SQL ?
  534. Setting a default schema for a particular group
  535. Removing a record from resultset using SQL
  536. Define tablespaces with different size paging into DB2
  537. Handling Null from a stored procedure
  538. truncate table for DB2 - differences
  539. Hosting Robots On Terminal Server
  540. Can Not Create Database - DAS Is Not Active
  541. what is a fully qualified table name in DB2 ?
  542. Script for db2 backup
  543. DB2 Trigger syntax
  544. DB2 Trigger syntax
  545. HTTP Web Service Consumer
  546. db2 inplace reorg and log space
  547. Online Reorg of LOB data
  548. Federated Systems Question
  549. Accessing data from an intermediate results table
  550. Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001